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
what is metrics in software testing? give me a brief detail about it?
how to explain banking domain project in testing?
Explain the defect life cycle.
What are the RBI rules has to follow by a bank for online precesseing. ?
can you tell me how to write test cases for payments, receipts, inward clearing, outward clearing, A/c statements ?
How do u prepare test environment for ur application?
How soon the bug should get fixed?
What is the difference between load and stress testing?
What is smoke test? Do you use any automation tool for smoke testing?
explain ur testing project? how can u nexplain . what should we explain ? i have not worked on any project?
sanity testing is done during regression testing.is it true.if it is true plz explain?
What are differences between Testing in Uncontrolled Environment and Abnormal Environment?
What is strategy to be followed for execution of 500 Test Cases in One day. If only 1 Resource is available.
What is early testing?
Can you explain exploratory testing?