Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361092 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 column?
What is inner join in sql?
What is difference between cursor and trigger?
What is execute immediate?
What packages are available to pl/sql developers?
What is the use of sqldataadapter?
what happens if null values are involved in expressions? : Sql dba
How do I know if I have sql express or standard?
How can triggers be used for the table auditing?
What is a data manipulation language?
How is pl sql different from sql?
What is partition in sql query?
how to select first 5 records from a table? : Sql dba
What is on delete set null?
Give the order of sql select?
