how to find the second highest salary from emp table?
- 211 Answers
- 321909 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 / ashwini
select max(salary) from employee where salary < (select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
Is left join same as join?
what is csv? : Sql dba
What is natural join in sql?
Can we call procedure in select statement?
what is the difference between cluster and non cluster index? : Sql dba
What is latest version of sql?
What is the difference between count 1 and count (*) in a sql query?
What are packages in pl sql and also explain its advantages?
How do I add a database to sql?
Can function return multiple values in sql?
Which language is used in sql?
What is union and union all keyword in sql and what are their differences?
What packages(if any) has oracle provided for use by developers?
How to know the last executed procedure?
