Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / madhav
select ename from emp where sal=(select max(sal) from emp);
ENAME
---------
KING
--first execute the inner query like
select max(sal) from emp;
MAX(SAL)
---------
5000
--- after that salary value pass the outer query like
this
select ename from emp where sal=5000
ENAME
---------
KING
Email:thota.madhav@gmail.com
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How many types of privileges are available in sql?
Why do we use view in sql?
Explain table and field in sql?
What are the types of triggers in sql?
How do I order columns in sql?
how to create a test table in your mysql server? : Sql dba
how would you get the current date in mysql? : Sql dba
What is multiple columns?
What is database sql?
Which one is faster ienumerable or iqueryable?
What is string data type in sql?
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.
What are the types of keys?
What is normalization in sql?
How many disk partitions should I have?
