select top 1 * from table where dept_no in(10,20) order by sal desc

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Question Posted / swati pise

24 Answers
29828 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / swati pise

select top 1 * from table where dept_no in(10,20) order by
sal desc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of sqldataadapter?

927

Why is a primary key important?

992

Can we use the cursor's to create the collection in PL/SQL?

984

i have some prob lem to tell me about my self in interview first round ...

2134

Is record in pl sql?

931

What is error ora-01000: maximum open cursors exceeded

1094

Can we connect to postgresql using sql developer?

962

Can we call procedure in select statement?

997

What is data manipulation language?

1156

How to revise and re-run the last sql command?

1125

What are the parameter modes supported by pl/sql?

1039

how can I make a script that can be bi-language (supports english, german)? : Sql dba

966

What are the 3 modes of parameter?

1129

How to run pl sql program in mysql?

974

Name the operator which is used in the query for pattern matching?

916