Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368433 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 / vikas naik
select max(sal) from employee where sal not in(select
max(sal) from employee);
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the need of merge statement?
What is clustered index sql?
Explain the working of primary key?
what is top in tsql? : Transact sql
What is sql lookup?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How do you write an index?
What is union and union all keyword in sql?
How do you delete duplicates in sql query using rowid?
How do I count duplicates in sql?
How do I view a view in sql?
Can we insert data into view?
List the ways to get the count of records in a table?
what is 'mysqld'? : Sql dba
How can I change database name in sql?
