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
- 29784 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
Explain candidate key, alternate key, and composite key?
Do you know what is user defined datatypes and when you should go for them?
What is raid? : SQL Server Architecture
What is sql profiler. What are the default templates with it? : sql server database administration
How many joins in sql server?
Disadvantages of the indexes?
What are system databases in ms sql server?
What are types of storage modes? : sql server analysis services, ssas
how can u get last observation in an unknown dataset ?
Explain the disadvantages/limitation of the cursor?
What do you understand by user-defined function in the sql server?
What are the different Topologies in which Replication can be configured?
How to find the login name linked to a given user name?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Does order by actually change the order of the data in the tables or does it just change the output?
