how to find the second highest salary from emp table?
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
What is sql profiler in oracle?
What is database migration?
What is a Mapplet?
what are the different type of sql's statements ? : Sql dba
What is cursor and its types?
How do I create an index in word?
What do you mean by table in sql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the most important ddl statements in sql are?
what are ddl statements in mysql? : Sql dba
how to extract a unit value from a date and time? : Sql dba
What is composite data type in pl sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What are the advantages of sql? Explain
What does where 1/2 mean in sql?