Answer Posted / a sameer
By using alias name too we can generate the query
A and B are two alias name for the employee table name
Query:-
select A.* from employee A where N=(selet count(Distinct
B.sal) from employees B where B.Sal > A.sal);
If any one want 2 or any other salary jut replace "the no."
required in place of N, to get the answer.
Hope might understand
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
1. what is a date guidelines ?
Hi all, can anyone tell me what is the selection procedure in Birlasoft for Manual Tester?It will be a great help.
what is the test plan of facebook?
How do u determine,what to be tested?
Can any one explain me about hybrid integration testing? and what is interface in integration testing? thanks in advance...... regards, MurthySharma.Manchella
what are the 3 test tool categories and describe what each can do.
Describe to me what you see as a process. Not a particular process, just the basics of having a process.
What is configuration management in software testing ?
How to write test case for view the table(i.e it is already stored in database and see the content in the table)
Explain what is exhaustive testing?
What is the difference between load and stress testing?
negative test cases on banking domain ?
test cases for compose functionality of gmail
What is the different between SIT and UIT?
If project wants to release in 3months what type of risk analysis you do in test plan?