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
- 30300 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulasi ravi kumar
hi this is tulasi ravi
id - ravi106109@gmail.com
select empno,sal 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 ? | 3 Yes | 5 No |
Post New Answer View All Answers
How will you decide the active and passive nodes?
List out the differences between the clustered index and non-clustered index in sql server?
What are pages and extents? : SQL Server Architecture
How to delete existing rows in a table?
What is the template in sql?
You want to implement the many-to-many relationship while designing tables. How would you do it?
explain databases and sql server databases architecture? : Sql server database administration
What different steps will a sql server developer take to secure sql server?
What are the advantages of using stored procedures?
How to loop through the result set with @@fetch_status?
What is rs.exe utility?
When cursors are useful?
What are the different methods available under sqlcommand class to access the data?
Explain transaction server implicit?
What does <> symbol mean?
