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 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
What kind of problems occurs if we do not implement proper locking strategy?
How to delete duplicate records based on single column from a table?
Tell me the difference between clustered and non-clustered index?
Explain can you implement data mining in ssrs?
What is 4nf in normalization form?
What is the correct order of the logical query processing phases?
What is the command dbcc checkdb used for?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is normalization of database?
What are the steps you should follow to start sql server in single-user mode?
What happens when converting big values to numeric data types?
How do I edit a procedure in sql server?
Should you normalize audio?
Mention what are the different types of ssrs reports?
what does the automatic recovery do? : Sql server administration