wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / pawan k. dubey
1-select * from employee where emp_id >(select count(*)-3
from employee)
2-select * from employee where emp_id in
(
select top 3 emp_id from employee order by emp_id DESC
)
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Write a sql query to sort on different column name according to the parameters passed in the function?
What are the advantages of using a stored procedure?
What is GUID in sql server?
What is RMS migrations?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is logon trigger?
What is 1nf 2nf and 3nf?
What is the data type of time?
What are examples of triggers?
What is partitioned view?
What is store procedure?
What is inner join in sql server joins?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
How to add code to the existing article (using improve article)?
How global temporary tables are represented and its scope?