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
How is use pl and sql?
Are pl sql variables case sensitive?
What does pragma mean?
What is numeric function sql?
Why are sql stored procedures used?
Can you load data into multiple tables at once? : aql loader
How do I edit a trigger in sql developer?
What are the query optimization techniques?
What is coalesce sql?
What are the sql commands?
Define the select into statement.
How does sql developer connect to oracle database?
What is a data manipulation language?
What is nvarchar max in sql?
what is denormalization. : Sql dba