wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 27276 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 a cube? : sql server analysis services, ssas
What do you mean by authentication modes in sql server?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
How to delete duplicate rows?
What is the command used to check locks in microsoft sql server?
How do I trace a query in sql server?
Determine when an index is appropriate?
can an order by clause be used in a creation of a view?
what is a mixed extent? : Sql server administration
Can you explain what is sql server english query?
What is simple indexing method?
How to update a field in SQL after ALTERING a row?
Can we create clustered index on composite key?
What is extended stored procedures?
what's the difference between delete table and truncate table commands? : Sql server database administration
