Write a query to get last 10 records from the table.

Answer Posted / akshaya

select * from last10
minus
select * from last10
where row >= (select COUNT(*)-10 from last10)


condition should be >= not <=
for all the above queries

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is use pl and sql?

749


Are pl sql variables case sensitive?

786


What does pragma mean?

726


What is numeric function sql?

734


Why are sql stored procedures used?

812


Can you load data into multiple tables at once? : aql loader

812


How do I edit a trigger in sql developer?

718


What are the query optimization techniques?

715


What is coalesce sql?

713


What are the sql commands?

807


Define the select into statement.

788


How does sql developer connect to oracle database?

754


What is a data manipulation language?

764


What is nvarchar max in sql?

761


what is denormalization. : Sql dba

785