Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367831 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 / gaurav singh 'viccky'
select salary from user=(select max(salary)from user where
salary < (select max(salary)from user))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is acid property in database? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What are different types of tables in sql?
What is parameter substitution in sql?
What is bind reference and how can it be created?
how can we submit a form without a submit button? : Sql dba
How many tables can you join in sql?
What is on delete restrict?
How to load data with sql*loader?
How do you modify a table in sql?
Can we use pl sql in sql server?
How to display Row Number with Records in Oracle SQL Plus?
Why is pl sql needed?
What operating systems are supported by oracle sql developer?
How to get each name only once from an employee table?
