Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 61279 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / yogesh
A little correction:
sol2> select salary from emp order by salary desc limit 1,1;
select salary from emp order by salary desc limit n-1,1;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What new data source types were added in ssrs 2014?
How the authentication mode can be changed?
How to find out what is the default collation in a database?
What is SQL Azure?
What are the restrictions that views have to follow? : SQL Server Architecture
Does partitioning improve performance?
How to connect ms access to sql servers through odbc?
what is checksum in sql server.........???
What is difference between view and materialized view?
how would you store your query in an SSRS report or a Database server?
Explain about SQL server 2005?
Where do we use trace frag?
What is create command?
Do you know the different ddl commands in sql?
What command would you use to add a column to a table in sql server?
