Interested to Buy Any Domain ? << Click Here >> for more details...
An employee table, with the columns id, name, sal and
dob.Query to select emp names of all highest salaries(there
are 4-5 people having the same salary which happens to be
the highest).
- 5 Answers
- 9236 Views
- ADP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sujan thota
select name from emp where sal=(select max(sal) from emp)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / varun b n
select * from emp where sal = (select Max(sal) from emp)
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / n. pavankumar
select * from emp where sal in (select max(sal) from emp)
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / naveen kamatam
select ename, salary from emp e
where 4 > (select count(distinct salary)from emp where
Salary > e.salary)
it will fetch top 4 high salary records
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / n@n!
emp table= emp;
column id =column_id;
name = name;
sal= sal;
dob= dob;
select top 1 name,sal,column_id,dob from emp order by sal
desc
while u run this query only one row was effected which
shows employee taken highest salary along with details like
column id,dob,name,sal.
if u want 5 employees list then replace top 1 by top 5
plz let me know if it was wrong (along with ur
query)...................
| Is This Answer Correct ? | 0 Yes | 5 No |
when do u stop testing?
what is verification and validation,
I m 2009 pass out B.E. student and still searching job.last 3-4 interviewer asked me why r u not selected any company till now...but i didn't give properly answer so any one can tell what should i have to say abt this which will give positive impression to interviewer.
What type of Testing u done ur project?
1.What are the difference b/w client & server?
1.what are the different types of testing techniques ?
Please is there any one working with ITR.COM? Having interview with them. Any tips will help.
Hi everybody. In an interview i was asked to write the ECP for the range (1-10).
In V model how will you explain all testing types (unit,integration,sysetem,acceptance testing) as all these parallel testing.E.g.Once the design phase is completed how will you do the integration teting over here as tester doesnt know much about design.Briefly justify the V-model?
hi i am kavita. i have completed software testing course.i am electronics background.my testing as question is why choose in software testing as a career.plz send me this answer and help me.
How to write Test cases for pen in tabular form including all phase of test case like Test id, Test Objective, Prerequisite etc.
approx how long a simple website take time just for manual testing including report generation.
Automation Testing 
