Write a query to get last 10 records from the table.
- 12 Answers
- 23975 Views
- iNautix, I also Faced
- E-Mail Answers
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 to call a javascript function from pl sql?
Is sql database free?
What is union, minus and interact commands?
What is sqlcontext?
how to include character strings in sql statements? : Sql dba
What is difference between sql function and stored procedure?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are the different set operators available in sql?
Is sql scripting language?
What is the default isolation level in sql server? : Transact sql
What is the purpose of design view?
What is left join in sql?
Is sql better than access?
How can I get the number of records affected by a stored procedure?
Can we change the table name in sql?
