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
When did u complete testing ? Which scenrio should not be in automation testing ? why ?
what are the risk factors in the project? what is the base for testplan and entry criteria ,exit criteria for test plan?
How will u decide test data to see that evey feature is thoroughly tested
Test cases have written according to Flow of the software working or according to Screens?
What is Snapshot Testing? When we need to do and who will involve in this process and also what is the output document of this testing
Testcases for msword( microsoct office word??
Want to learn Manual Testing in just two days? Students around Thanjavur, Trichy, Mayavaram and Kumbakonam Mail to manualtestingtraning@gmail.com. Entire Manual Testing Concept. Any doubt regarding IT Job please mail above ID
why use caffine for HPLC calibration ?
Can you explain an application boundary?
hello frens. Im Arun from the uk. im planning to apply for tester jobs with 3yrs experience. the problem is i dont have resumes. i have to mention atleast 3 projects (preferably financial projects) in my CV. im totally blank. can u plz send ur CV's to my email.... arunmoses1982@yahoo.com. this would be a great help from you guyz. n u need any help from me? just mail me n ill get in touch with u. Thanx.
In our project, we use Withdrawal Indent, we are confused to use heading as "Withdrawal Indent" or "Withdraw Indent". Please suggest me which one to use ASAP, Thanks in advance
write testcases for open dialogbox
what is data guidelines
what should be tested when credit card is used as payment option in ecommerce project?can anyone tell me in detail what to test n how to test when credit card is involved in web application?
how can u prepare the test plan?
