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
- 31236 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 are data types in pl sql?
What is nosql example?
What is faster join or subquery?
what is self-join? : Sql dba
what is union? : Sql dba
Explain what is a field in a database and record in a database?
What does seeding a database mean?
Why use triggers in sql?
How do you update f as m and m as f from the below table testtable?
what is a constraint? Tell me about its various levels. : Sql dba
What are the different types of functions in sql?
What is sql*loader and what is it used for? : aql loader
How can you get sql*loader to commit only at the end of the load file? : aql loader
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How to revise and re-run the last sql command?
