Interested to Buy Any Domain ? << Click Here >> for more details...
wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 30297 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulasi ravi kumar
hi this is tulasi ravi
id - ravi106109@gmail.com
select * from emp where rowid in
(select rowid from emp
minus
select rowid from emp where rownum<=(
select count(*)-3 from emp))
feel free to mail queries,,,.....
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the difference between SQL notification and SQL invalidation?
What is sql server database?
What are recommended options to be used while using db mirroring? : sql server database administration
How to insert multiple rows with a subquery?
How to create new table with "create table" statements?
What do you understand by integration services in sql server?
Can you explain the disadvantages/limitation of the cursor?
What are the purpose of Normalisation?
Determine when to use stored procedure to complete sql server tasks?
How does stuff differ from the replace function?
What is the xml datatype?
What is use of except clause? How does it differ from not in clause?
How many triggers are possible per table?
How can you stop stored procedures from recompiling?
What does nvl stand for?
