Given an employee table, how would you find out the second
highest salary?
- 9 Answers
- 11639 Views
- I also Faced
- E-Mail Answers
Answer Posted / mithilesh mishra
Select Max(sal) from emp where sal not in (select max(sal)
from emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is a database development?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
State the acid rules?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How would you design a database for an online site, which would average a million hits a day?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How you can make a parameterized view?
Explain the process of the user request and data generating?
Why does this query return 0?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain the cube operator?
Who are naive users?
What is an application role and explain a scenario when you would use one?
How to combine two function together?
