how to find the second highest salary from emp table?
- 211 Answers
- 320868 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / karthik.k
select max(salary) as second_highest from emp where salary
< (select max(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are all the common sql function? : Sql dba
How do rank () and dense_rank () differ?
Is trigger a stored procedure?
What is nvl?
What are the different types of sql commands?
Why join is faster than subquery?
Why do we use set serveroutput on?
What is the largest value that can be stored in a byte data field?
Can you selectively load only those records that you need? : aql loader
what are the difference between clustered and a non-clustered index? : Sql dba
Explain architecture of sql server notification services?
what are the advantages a stored procedure? : Sql dba
What is cascade in sql?
Is there a 64 bit version of ssms?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
