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

Answer Posted / suresh naik

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is vector point function?

770


What sql database should I use?

788


How do you define a foreign key?

721


What is a design view?

700


how to use in conditions? : Sql dba

693






Enlist some predefined exceptions?

797


How to make a copy values from one column to another in sql?

769


What is hibernate and its relation to sql?

789


how to show all tables with 'mysql'? : Sql dba

816


What is assignment operator in pl sql?

764


How do I remove duplicates in two columns?

697


What are sql constraints?

788


Why do we use procedures in pl sql?

721


What is application trigger?

733


What is parallel hint?

937