how 2 find out nth salary.plz write sql qurires
Answer Posted / yogini_bhosale
select MAX (salary from employee)
where
salary not in ( select TOP N+1 salary from employee)
ORDERBY salary desc();
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hello. I am not here to answer your question. I jus found a job as software QA engr. And i am totally new to software testing. So can someone pls help me in the following scenario? there is this registration screen, and it contain: One textbox called Nickname which only accept alphanumerical One textbox called Contact which only accept numerical, One textbox called Email which can be filled with alphanumerical and symbol and One button called Register now becos there is so many textboxes, where i can filled with alphabet, number, symbol, "just space", leading zeros, leading space. there will be lots of combination. can someone pls help.. i will be appreciated if u can post the test case of the scenario i mentioned. Lots of Thanks
What is un-installation testing?
What will be your approach if a particular script in Load Test fails?
What is AGP?what is setup.inf?What are the ways to install driver?
What are the different test techniques used in functional testing?
How to do Performance Testing manually for a Flash Application?
HI GUYS,, I HAVE 3 YEARS OF EXP IN MANUAL TESTING...NEXT MONTH ONWARDS I WORK FOR MOBILE TESTING....PLS SUGGEST ME WHAT I LEARN FOR TRAING,, MOBILE TESTING OR ANDROID....FOR MOBILE TESTERS NEED ANDROID(IFONE) DEVOLOPMENT KNOWLEDGE OR NOT? EXPLAIN CLEARLY
i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.
What is coverage and what are the different types of coverage techniques?
what are the typical problems in web testing?
Hi Please tell me about ERP Project how do describe in interview Please tell me details about this project my id is chiku_69@yahoo.in
I have to give weights to 5 stones so that using a simple balance and the stone i should be able to weight any number between 1-100
Being an Manual tester, what will be the role or activity in test plan ?
how to explain banking domain project in testing?
What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?