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

Answer Posted / chandu

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

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use ddl commands in pl sql?

766


Explain what is a database?

815


what are the authentication modes in sql server? How can it be changed? : Sql dba

956


How can I change database name in sql?

703


What is pl sql script?

731






What is difference between table and view?

706


how to enter numeric values as hex numbers? : Sql dba

770


Does truncate require commit?

715


How does a self join work?

693


What do you mean by stored procedures? How do we use it?

712


what is cross join? : Sql dba

742


What is a constraint?

729


What is sqlerrd?

699


What is sql architecture?

747


Can we use having without group by in sql?

732