Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373094 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
how tsql statements can be written and submitted to the database engine? : Transact sql
what is view? : Sql dba
What is the difference between row level and statement level trigger?
What are all the common sql functions?
What is the maximum number of rows in sql table?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How can I change database name in sql?
How to return an array from java to pl/sql?
Why do we create views in sql?
What is the difference between nvl function, ifnull function, and isnull function?
what is query cache in mysql? : Sql dba
how to rename an existing table in mysql? : Sql dba
What are tuples in sql?
what is data control language? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
