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
- 29919 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
What is a filestream?
Why it is recommended to avoid referencing a floating point column in the where clause?
What is row_number () and partition by in sql server?
Can select statements be used on views in ms sql server?
What is a join in sql? What are the types of joins?
Explain the properties of a relational table?
when would you go for denormalization? : Sql server database administration
How to edit table in sql server 2017?
Explain log shipping and mention its advantages.
Name few of the dcl commands in sql?
What are the different types of sql server replication? : sql server replication
How will you add a dimension to cube? : sql server analysis services, ssas
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Can we call future method from trigger?
What is sql server query analyzer?
