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.
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 different sql data types?
what are the join types in tsql? : Transact sql
Are sql database names case sensitive?
What is the least restrictive isolation level? : Transact sql
What is gpt format?
What are the types pl/sql code blocks?
What is sap sql?
What is pl/sql language case sensitive?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
what is self-join? : Sql dba
What is the difference between syntax error and runtime error?
how to delete an existing column in a table? : Sql dba
Mention what are the benefits of pl/sql packages?
What is a database? Explain
What is sqlca in db2?