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
Why is sql server log file full?
What does the on delete cascade option do?
How do I edit a stored procedure in sql server?
What is trigger explain with program?
In which tcp/ip port does sql server run? Can it be changed?
How to insert new line characters into strings?
Differentiate between SQL and ORACLE joins and write their syntax.
What is candidate key with example?
System variable and temporary variables
How the authentication mode can be changed?
What is difference between materialized view and view?
What is the difference between Normalization and De-normalization?
What is not null constraint?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is the optimization being performed in oracle and SQL Server?