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

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

Please Help Members By Posting Answers For Below Questions

How do I write a sql query in pgadmin 4?

992

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1197

what is the difference between group by and order by in sql? : Sql dba

1133

Why plvtab is considered as the easiest way to access the pl/sql table?

1218

What is rtm stands for?

1106

What is orm in sql?

1052

What are all the ddl commands?

1187

What is error ora-01000: maximum open cursors exceeded

1150

What is the difference between stored procedure and view?

1021

What do you mean by rowid?

983

Which is faster count (*) or count 1?

1038

What is schema in sql?

956

Can we use update in sql function?

1069

what is denormalization. : Sql dba

1120

how to use 'mysql' to run sql statements? : Sql dba

1059