How to select nth record from a table?
Answer Posted / veeresh kethari
select min(sal) from EMP where sal in(select top n sal from
EMP
order by SAL desc)
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to test subquery results with the exists operator?
What is the difference between delete and truncate statements?
What are the different type of replication in sql server?
What do you mean by data manipulation language?
What is the user of Primary key?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
How to use copy and concatenate commands in SQL?
What is dimension table? : sql server analysis services, ssas
Explain few of the new features of sql server 2008 management studio
What is data source in connection string?
What are the types of dml?
Is null in sql server?
What is the difference between functions and stored procedures?
What is usually the first word in a sql query?
How to bind a view to the schema of the underlying tables?