Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / wei
The best answer should be the first one, this is because
the sql statement accesses table emp only once.
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What is cursor and why it is required?
Can cursors be part of a trigger body?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Is coalesce faster than isnull?
How to make a copy values from one column to another in sql?
What is informix sql?
How would you convert date into julian date format?
Can we use ddl statements in stored procedure?
Which is the correct statement about truncate and delete?
What is difference sql and mysql?
What is union and union all keyword in sql?
What is difference between procedure and trigger?
What is set serveroutput on in pl sql?
What is cursor in pl sql?
What is rowid in sql?