Interested to Buy Any Domain ? << Click Here >> for more details...
how 2 find out nth salary.plz write sql qurires
- 8 Answers
- 11689 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
what are metrics and what are metrics did u collect in you are project
tell wat u did in ur banking project?
What is the role of the test group vis-?is documentation, tech support, and so forth?
What are the challenges you faced in your project (Testing) and in your company?
I am a ISTQB cerfity tester with 3 yrs experience(kolkata) , I left my current commpany due to some problem but since two months I did not get new job , why? is my age is 33 yrs and I am married . If anybody have any answer please let me know, my email id sangitadas1981@gmail.com/yahoo.co.in
1.what promted you to become involved in QA/Testing?
What is your daily process? I have 2+EXP IN MANUAL TESTING.PLEASE SUGGEST ME HOW i ANSWER
Do you know anything about Set Top Boxes?
When did u complete testing ? Which scenrio should not be in automation testing ? why ?
How to do security implementation for any URL??
What is a code walk through?
How we can test Cookies Manually?
I need your help, actually am facing lots of problem in interview am not able to answer in right way what ever questions asked about project. Could you please answer few questions? You must have seen the project I have mention as current project so please help on this, tell me how to explain project in details am prepare on HR module but don’t know how to explain it properly. If you can send me few documents like SRS, and few test case that will help me to get the clear picture, and want ask u what is tier1, tier2, and tier3 in project.
Can Anbody please send me Daily Work status format in which I can save my daily work activity
if go through 1 or 2 projects clearly,then i feel comfortable to search the job,please help me
