Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 372944 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 / manvar prajesh
select top 1 name,salary from emp where salary<(select
max(salary) from emp)order by salary desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you fetch first 5 characters of the string?
Can we write dml inside a function in sql server?
What are different types of keys?
What happens when a trigger is associated to a view?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
How many postgresql users are there, worldwide?
What are the two virtual tables available at the time of database trigger execution?
What do you mean by stored procedures? How do we use it?
What is break?
What is relationship? How many types of relationship are there?
What is normalization in a database?
What are sql commands?
Which sorts rows in sql?
Explain the uses of a database trigger?
Why do we use cursors?
