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

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

Question Posted / suresh naik

Answer Posted / suresh naik

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we create view in stored procedure?

946

How can I make sql query run faster?

996

Which operator is used in query for pattern matching?

1075

What is sql query limit?

962

What are the features of pl sql?

1054

What is procedure explain with example?

941

What is sql deadlock?

1114

What is clustered and nonclustered index in sql?

931

What are the different types of database management systems?

983

How is indexing done in search engines?

973

how to include numeric values in sql statements? : Sql dba

1086

How is use pl and sql?

1052

What are the ddl commands?

993

How do I use google cloud in sql?

1070

How much does sqlite cost?

1028