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
What is primary key and example?
How can you hide the sql server instances?
between cast and convert which function would you prefer and why?
explain different levels of normalization? : Sql server database administration
What are wait types?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How to execute stored procedure and set temp table in sql server?
What are types of subqueries?
What are xml indexes?
Can you move the resources after pausing the node? : sql server database administration
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What happens if null values are involved in bitwise operations?
Can you use order by when defining a view?
Explain what is lock escalation and what is its purpose?
Explain about integration services of Microsoft SQL server?