how to find the second highest salary from emp table?
- 211 Answers
- 320834 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 / subahar
SELECT MAX(average) AS Expr1
FROM sp
WHERE (average NOT IN
(SELECT MAX(average) AS Expr1
FROM sp AS sp_1))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is null in pl/sql?
How do I create an index in word?
How many types of primary keys are there?
What is assignment operator in pl sql?
What are different types of triggers?
How do you rank data in sql?
Is sql procedural language?
What is normalisation in sql?
Do we need to create index on primary key?
Can we rename a column in the output of sql query?
what are the performance and scalability characteristics of mysql? : Sql dba
What is function and procedure?
What pl/sql package consists of?
What is the difference between python and sql?
What is a dynamic query?
