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

The project manager is working with the team to help them understand the constraints the project must operate within. As a kick off to the meeting, the manager displays the first slide, which reads: Scope, Schedule and Budget--You may pick two. Based on the above scenario, which one of the project concepts is the manager relating to the team?

2 Answers  

what are the main challenges faced in ur project?

5 Answers  

What is agile methodology

2 Answers   Nucleus Software,

What is web based application?

3 Answers  

What is Memory Leak? How to test "Memory Leak" problem in an application manually?

2 Answers   HCL,

what is suspension criteria in your test paln and explain one suspension criteria in your test paln,... pls give one real time example

3 Answers   Satyam,

What is the goal of Software Configuration Management(SCM? a.)Configuration Identifier b.)Configuration Control c.)Process Management d.)All options.

2 Answers   Amdocs,

in what order should i answer for the question "tell me abt your self"

3 Answers  

What is Tracebility Matrix ? What is there in that and what will u do with that ?

15 Answers   CTS, Polaris,

How quickly we need to fix the bug? Or how soon the bug should get fixed?

0 Answers  

howmany buids u hav in u r project , for how many days u get build

2 Answers   Diebold,

Which test cases are first written white boxes or black box?

1 Answers