Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373082 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 / rajkumar
SELECT * FROM TABLE WHERE columnName =
(SELECT MAX(column_name) FROM TABLE WHERE
column_name<(SELECT max(column_name) FROM TABLE))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is varchar sql?
What is the difference between left outer join and left join?
What is package in pl sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
How do I use google cloud in sql?
What are tables and fields?
Is nosql relational?
What is group by in sql?
What are different types of sql?
What are the three forms of normalization?
What is the usage of when clause in trigger?
how do you know if your mysql server is alive? : Sql dba
What is prepared statement in sql?
Can we join two tables without common column?
What is auto increment?
