how to find the second highest salary from emp table?
- 211 Answers
- 321905 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 / winnie
select max(sal) from emp
where sal not in (select max(sal) from emp )
| Is This Answer Correct ? | 1090 Yes | 131 No |
Post New Answer View All Answers
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
how to create a new table by selecting rows from another table in mysql? : Sql dba
what is sql? : Sql dba
what is blob? : Sql dba
how many columns can be used for creating index? : Sql dba
What are the different schemas objects that can be created using pl/sql?
what are sequences
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is function and procedure?
How do I partition in sql?
What is Materialized View? In What Scenario we Use Materialized View?
how to create a new table in mysql? : Sql dba
How to handle bulk data?
Does access use sql?
What is the difference between left join and right join?
