Answer / sujan thota

select name from emp where sal=(select max(sal) from emp)

Answer / varun b n

select * from emp where sal = (select Max(sal) from emp)

Answer / n. pavankumar

select * from emp where sal in (select max(sal) from emp)

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

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)...................

which process u followed in ur company?

2 Answers  

How do you test if you have minimal or no documentatioabout the product? How do you decide when you have tested enough? How do you determine what to test?

3 Answers  

At what stage of the life cycle does testing begin?

2 Answers  

What is meant by SIT?

2 Answers  

What is known issues?

5 Answers   Covansys,

For Change Password functionality-- Test Case is -- > Change Password Test Steps/Descriptions: 1) Enter Old Password 2) Enter New Password 3) Enter Confirm Password 4) Click on Save button Expected -- > User should login successfully. My question is --> After 4th step tester will check/verify that user [whose password has been changed] is login successfully or not. Should I have to write that steps which user will fallow to verify user login in above test case? What are the preconditions for above test case?

6 Answers  

can you tell me high priority low severity defect?

2 Answers  

difference between regression testing and re testing?

14 Answers   Bizpivot, CTS,

What exactly we have to say when interviewer asked "Tell me about your self"?

2 Answers  

wat kinds of documents requied during regression testion ? at time regression testing is done? can we do it repeatdly

2 Answers  

what are the different type of bugs in client server and web based?and what is the difference in testing client server and web based?

6 Answers   Tanla Solutions,

What is field testing?

3 Answers   UST,