Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 32311 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / ramesh.p
Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;
| Is This Answer Correct ? | 10 Yes | 19 No |
Post New Answer View All Answers
What are % type and % rowtype?
Is microsoft sql free?
What is a join query?
What is the execution plan in sql?
How do I save a sql query?
how to convert character strings to numeric values? : Sql dba
What is cartesian join in sql?
Mention what does the hierarchical profiler does?
How do I view stored procedures?
How does a trigger work?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Who is the owner of mysql database?
What are the types of queries in sql?
What is memory optimized table?
How do you determine the current isolation level? : Transact sql
