wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / teja
select * from employee where emp_id in
(select top 3 emp_id from employee order by emp_id DESC)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Tell me what is normalization? Explain different forms of normalization?
What are binary string data types in ms sql server?
What are the types of dml?
Can we use where clause in union?
List some case manipulation functions in sql?
What are the advantages of paper records?
What are the basic features of a trigger in ms sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Do you know what is similarity and difference between truncate and delete in sql?
What are the limitations in ssrs on sql server express edition?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is database dimension? : sql server analysis services, ssas
What is attribute hierarchy? : sql server analysis services, ssas
Why we need sql server?
What the different components in replication and what is their use?