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
- 29225 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
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is isolation levels?
How to define and use table alias names in ms sql server?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
User wants only to display only pdf as export option in report manager. How to achieve this?
How can I get data from a database on another server?
What is policy management?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Can we use where clause with group by?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is store procedure? When do you use?
Detail about query optimizer?
What are the different subsets of sql?
Why use stored procedures in sql server?
what type of index will get created after executing the above statement? : Sql server database administration
