Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361450 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 / bharat puri
select top 2 (salary) from emp
order by salary desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a pl/sql block?
What are stored procedures used for?
What are the three forms of normalization?
How many triggers can be applied to a table?
What will you get by the cursor attribute sql%notfound?
What is record type in pl sql?
i have some prob lem to tell me about my self in interview first round ...
What are aggregate and scalar functions?
What is the difference between subquery and correlated query?
what are ddl statements in mysql? : Sql dba
What does the sign mean in sql?
Can a foreign key have a different name?
When sql appeared?
how to fetch common records from two tables? : Sql dba
What is foreign key and example?
