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
Please differentiate between a local and a global temporary table?
What is meant by Active-Passive and Active-Active clustering setup?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
can a database be shrunk with users active? : Sql server administration
What is rank function?
How to assign new column names in a view?
Which are the olap features?
Data table as parameter in sql server?
List out some of the requirements to set up a sql server failover cluster?
What is a non-clustered index?
What is field with example?
How many database files are there in sql server 2000?what are they?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What are the new features are introduced in sql server 2012 reporting services?
What is difference between order by and group by?