Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368623 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
Explain how can you save or place your msg in a table?
What is execute immediate?
How does sql profiler work?
Can we insert data in view?
What is normalization in a database?
How many types of primary keys are there?
How many sql statements are used? Define them.
What is triggering circuit?
How to use distinct and count in sql query? Explain
What is an escape character in sql?
Where is sql database stored?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is dml statement?
What is sql*loader and what is it used for?
Does db2 use sql?
