wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
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 shared lock?
Can we add an identity column to decimal datatype?
What is a covering index?
How to create sub reports?
what are different types of raid configurations? : Sql server database administration
How to create user defined functions with parameters?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
how to do partition in sqlserver
What are the mathematical functions supported by sql server 2005?
What is the difference RDBMS and Graph Database?
Mention what are the core components of ssrs?
How to create a store procedure with encryption?
What are the system database in sql server 2005?
What are the differences between local and global temporary tables?
How to create a new login name in ms sql server?