Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367643 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 / bharath konegadde
Select Emp_Name from emp_table where Id=(Select Emp_Id from Salary Order By salary Desc limit 0,1)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you have more than one key in a database?
Explain the uses of a database trigger?
List the various privileges that a user can grant to another user?
What is the unique index?
What are the subsets of sql?
Does a primary key have to be a number?
What are views in sql?
What is relationship? How many types of relationship are there?
How many aggregate functions are available there in sql?
What is scalar data type in pl sql?
Explain the advantages and disadvantages of stored procedure?
Can we use join in subquery?
How many types of literals are available in pl sql?
What is an inconsistent dependency?
How is a PL/SQL code compiled?
