how to find the second highest salary from emp table?
- 211 Answers
- 320941 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 / jat16may
SELECT MAX(SALARY) FROM TABLENAME WHERE SALARY<(SELECT
MAX(SALARY) FROM TABLE NAME
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the use of stored procedures?
what are the disadvantages of mysql? : Sql dba
How do you update sql?
Which are the different character-manipulation functions in sql?
What steps server process has to take to execute an update statement?
How delete a row in sql?
Can dml statements be used in pl/sql?
Does truncate require commit?
What are the different types of functions in sql?
Why commit is not used in triggers?
How many types of functions are there in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is composite data type in pl sql?
How many types of indexes are there in sql?
What is dynamic sql in pl sql?
