Select Emp_Name from emp_table where Id=(Select Emp

how to find the second highest salary from emp table?

Question Posted / bharath konegadde

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

Please Help Members By Posting Answers For Below Questions

What is sql profiler in oracle?

1162

What is database migration?

1013

What is a Mapplet?

1200

what are the different type of sql's statements ? : Sql dba

981

What is cursor and its types?

1156

How do I create an index in word?

1077

What do you mean by table in sql?

1045

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?

1108

What is the most important ddl statements in sql are?

1043

what are ddl statements in mysql? : Sql dba

1269

how to extract a unit value from a date and time? : Sql dba

1042

What is composite data type in pl sql?

1170

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1210

What are the advantages of sql? Explain

1156

What does where 1/2 mean in sql?

1145