select distinct sal,ename from emp where sal=(select max(sal) from emp);

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Question Posted / manoj k

16 Answers
25022 Views
I also Faced
E-Mail Answers

Answer Posted / manoj k

select distinct sal,ename from emp
where sal=(select max(sal) from emp);

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is memory optimized table?

1086

What is mutating error in pl sql?

1066

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4464

What are the ddl commands?

1055

how to analyze tables with 'mysqlcheck'? : Sql dba

1062

What is a dirty read sql?

1247

What is the difference between partition and index?

1062

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1186

What is data type in database?

1043

what are all types of user defined functions? : Sql dba

1089

What is a column in a table?

1189

How do you know if a relationship is 2nf?

995

What is the syntax and use of the coalesce function?

1216

What are sql functions? Describe the different types of sql functions?

1215

How long will it take to learn pl sql?

981