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

Answer Posted / selvaraj v , anna university c

select ename, salary from emp where salary=(select max
(salary) from emp) order by emp_no;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many times can we commit in a loop?

564


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

593


What is trigger explain it?

547


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6070


what are the differences between binary and varbinary? : Sql dba

529






Can we write dml inside a function in sql server?

495


What is union?

649


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

574


What is difference between stored procedures and application procedures?

567


Can you join a table to itself?

539


How to use sql statements in pl/sql?

578


What is primary key and foreign key with example?

494


Can we have two clustered index on a table?

559


what are the 'mysql' command line arguments? : Sql dba

644


which tcp/ip port does sql server run on? : Sql dba

514