Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368417 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 / jat16may
SELECT MAX(SALARY) FROM TABLENAME WHERE SALARY<(SELECT
MAX(SALARY) FROM TABLE NAME
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Explain what is sql*plus?
What is sql stand for?
what is offset-fetch filter in tsql? : Transact sql
How delete a row in sql?
How many indexes can be created on a table in sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
How to run sql functions in pl/sql?
How to make a copy values from one column to another in sql?
What are the usages of sql?
what is the difference between primary key and unique key? : Sql dba
Can we call procedure in select statement?
Where is pl sql used?
How to run pl/sql statements in sql*plus?
How do I view tables in sql developer?
what is difference between delete and truncate commands? : Sql dba
