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
- 29502 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 to create a view with data from multiple tables?
What is the difference between resultset and resultsetmetadata?
Explain alternate key, candidate key and composite key in sql server?
What are a scheduled jobs or what is a scheduled tasks?
What is database dimension? : sql server analysis services, ssas
What are indexes in ms sql server?
wat wil hapn if we give the both read and deny read permission to user?
How to change the password of a login name in ms sql server?
How to declare and use cursor variables?
Explain in brief about Microsoft SQL server?
What are approximate numeric data types in ms sql server?
What is the cpu pressure?
What is the contrast between sql and mysql?
What is instead of trigger sql server?
How you can get the list of largest tables in a database?
