Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367897 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 / anonymous
select Max(salary) from test where salary not in(select Max
(salary) from test);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are local and global Indexes and where they are useful.
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is the use of stored procedures?
Can we insert in sql function?
How to rename a table?
what is 'mysqladmin' in mysql? : Sql dba
How do I start pl sql?
Can a composite key be null?
What is rank dense_rank and partition in sql?
Why do we use %rowtype & %type in plsql?
How do I kill a query in postgresql?
What is a constraint?
how to convert dates to character strings? : Sql dba
What is join view in sql?
What are sql indexes?
