Interested to Buy Any Domain ? << Click Here >> for more details...
how 2 find out nth salary.plz write sql qurires
- 8 Answers
- 12094 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / nagapawan
iam taking table name as emp. this is to find out nth salary
eg: select * from emp
where n-1 = (select count(*) from emp e
where emp.salary<e.salary)
in place of n-1 you can keep zero for first hight salary
and 1 for second hightest salary.....etc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
hi... guys can any one pls help me out.... I m civil engg graduate i want to come into s/w field... i have decided to do manual testing course. i know its not sufficient.. which r the other coures shall i do with this.. suggest me good atomation tool and SAP courses... thanks in advance.. i wil be thankfull to u all
What are the main key components in web applications?
What is white box testing, and what are the various techniques?
Hi Dear this urgent for me i have need of ROLTA India Ltd Mumbai Paper pattern for Testing Person , PLease Help me , if any body have any idea about it
What is white box testing?
Can you explain the workbench concept?
Hi Can any one tell wht type of questions will be asked in project manager round...urgent plz...
what is agile model and spiral maodel?pls explain with an example?
For any web application, what are the possible login features that should be tested?
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 looking for the software testing job with the exp of (1.5 yrs ), if anybody knows how to approach the companies ,pls let me know , possible que which will be asked in interview ? pls send me sample resume for testing ....pls do the favour as soon as posible .
how to test a store procedure?
Why do we need different environments and different data? What is the other name for environment? Justify your explanation ? real time experts pls xplain?
Hi friends, currently i am working with banking domain project in the part of testing..what kind of questions will be ask at interviews.. can anybody listout the project oriented questions which are asked in interviews...
hi all I have an overall experience of 12 years working in an EDP setup(worked in a manufacturing setup in a German MNC). On my request, I was relieved from my duties in Sep 06 for maternity reasons. However I would like to pursue a career in a software organization as a manual tester. I obtained my proficiency certificate in Software Testing from STAG SOFTWARE LIMITED 2 months ago i.e in May and would now like to continue working in this field. However I am unable to find a job until now. If anybody knows of a opening at bangalore, kindly let me know.
