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
- 29895 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 difference between getdate and sysdatetime in sql server 2008?
How to delete a database in ms sql server?
Explain the truncate command?
what is the sql equivaent of the dataset relation object ?
What are the advantages to use stored procedures?
What is bulkcopy in sql?
What is the process of normalising?
What is linked report?
What command would you use to create an index?
Explain the commands in sql server?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Can we create clustered index on composite key?
Do you know what is replace and stuff function in sql server?
What is a transact-sql statement batch in ms sql server?
Can sql server be linked with other servers like oracle?
