Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373289 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 / bell
SELECT TOP 1 FieldName FROM (SELECT TOP 2 FieldName FROM
Tabname ORDER BY FieldName DESC) allis ORDER BY FieldName
ASC
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the constraints available in sql?
Explain table and field in sql?
Explain sql data types?
What is left join example?
what are the differences between binary and varbinary? : Sql dba
What are keys in sql?
How many columns should be in an index?
When is the explicit cursor used ?
How is use pl and sql?
when is the use of update_statistics command? : Sql dba
what is myisam? : Sql dba
How to run sql functions in pl/sql?
What is a table?
What is the plv (pl/vision) package offers?
How many primary keys can a table have?
