Interested to Buy Any Domain ? << Click Here >> for more details...
consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.
- 24 Answers
- 30190 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / srilekha
select ename from table where sal=(select max(sal) from
table) and depetno in (10,20)
| Is This Answer Correct ? | 27 Yes | 20 No |
Post New Answer View All Answers
What is the syntax and use of the coalesce function?
What does dml mean?
what is difference between delete and truncate commands? : Sql dba
What does a pl/sql package consist of?
What is index example?
What is prepared statement in sql?
Show the cursor attributes of pl/sql.
What is pl/sql language case sensitive?
define sql update statement ? : Sql dba
How do I save the results of sql query in a file?
what is the difference difference between procedure and packages
What is rtm in testing?
What do you mean by query optimization?
what is the syntax for using sql_variant_property? : Transact sql
Why we use cross join?
