Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367446 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 / khushbu
select max(salary) from emp where salary not in (select
max(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many types of sql are there?
Can we create table inside stored procedure?
What are different types of keys?
How do you bind variables in pl sql?
what is the use of set statement in tsql? : Transact sql
Which are the different case manipulation functions in sql?
What are different methods to trace the pl/sql code?
What is the process of debugging?
What is the difference between the sql*loader and import utilities? : aql loader
explain the advantages and disadvantages of stored procedure? : Sql dba
How many unique keys can a table have?
How can you know that statistics should be updated?
How to write a query to show the details of a student from students table whose
Can we insert in sql function?
Is it important to partition hard disk?
