how to find the second highest salary from emp table?
- 211 Answers
- 322097 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 / sudha
select max(sal) from emp where sal <(select max(sal) from
emp);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I find duplicates in sql?
Can a select statement fire a trigger?
what are the 'mysql' command line options? : Sql dba
How do I edit a stored procedure?
Which tcp/ip port does sql server run?
Can we join two tables without common column?
what is schema? : Sql dba
What is sql and how does it work?
What is meant by temporal data?
Why use subqueries instead of joins?
what is the difference between truncate and drop statements? : Sql dba
What are sql injection vulnerabilities?
how to extract a unit value from a date and time? : Sql dba
How do I view a sql database?
What is dba in sql? : SQL DBA
