Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can software qa processes be implemented without stifling productivity?
How many bugs occured will be considerd appropriate over 1000 steps when inspecting software? Describle an approriate Bug value.
What is unit level testing?
How to do integration testing on duster......
what r the 5 major defects that u found in ur shopping related project?
What is the difference between authentication and authorization in web testing?
Can you explain calibration?
what is the cheklist to check SRS document (after releasing) as a test ingineer and how can we check
what is independent question and what is retriewing and what is problem of severity.
Have you prepared traceability matrix and how to prepare it?
Do you think tools are required for managing change. Explain and please list some tools/practices which can help you managing change.
Work flow in testing in your company?
How we allocate the priority(Blocker, Critical, etc.,) in Testing?
What is coverage and what are the different types of coverage techniques?
What are noise variables?
