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
- 29255 Views
- I also Faced
- E-Mail Answers
Answer Posted / amit kaishver
Select * from ( select rownum k,g.* from nbfc_bank_m g) h,
(select max(rownum) a,max(rownum)-1 b,max(rownum)-2 c
from nbfc_bank_m ) p
where h.k in (p.a,p.b,p.c)
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Explain sql delete command?
How to find table changes in sql server?
What are scalar functions in sql?
Write SQL queries on Self Join and Inner Join.
What are page splits? : SQL Server Architecture
How to rebuild the master database?
What is the exact numeric data type in sql?
How data can be copied from one table to another table?
How to scale out a federation by Sql statement?
Do you know what are acid properties of transaction?
How to modify an existing user defined function?
What do you mean by an execution plan?
what are the disadvantages of cursors? : Sql server database administration
What do you mean by sql server 2005 express management tools?
