Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get last 10 records from the table.
- 12 Answers
- 26838 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
Why is partition used in sql?
What is sql dialect?
What are different functions in sql?
How many scalar data types are supported in pl/sql?
what is acid property in database? : Sql dba
How do I sort a table in sql?
How is data stored in sql?
What is cartesian join in sql?
What is sql and db2?
Explain about various levels of constraint.
what are wild cards used in database for pattern matching ? : Sql dba
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Show how functions and procedures are called in a pl/sql block.
what is auto increment? : Sql dba
What does count (*) do in sql?
