Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361364 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 / ajeshanath
select max(salary) from emp where salary not in
(select max(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the different types of dbms?
how mysql optimizes distinct? : Sql dba
Define sql delete statement.
How do you optimize a stored procedure in sql?
What is primary key sql?
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's the difference between a primary key and a clustered index?
What is a full join?
What is trigger in pl sql?
What are the two virtual tables available at the time of database trigger execution?
What is full join in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What will you get by the cursor attribute sql%found?
What is sql architecture?
What are the different dcl commands in sql?
