two tables are there.1st table EMP has two columns ID and name and contains data 1,A
2,B
3,C
2nd table EmpSal has 2 columns ID and Salary
Contains data -1,1000
2,5000
3,3000
Find name of employee having maximum salary ?
- 5 Answers
- 4856 Views
- CSE, I also Faced
- E-Mail Answers
Answer Posted / gajula.lavanya
SELECT T1.NAME,T2.SAL FROM emp1 T1,emp2 T2
WHERE T1.ID=T2.ID AND T2.SAL=(SELECT MAX(SAL) FROM emp2);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain having clause?
What is the distinction amongst delete and truncate?
Define cross join in sql server joins?
What is inner join in sql server joins?
What is the contrast between sql and mysql?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are the advantages dts has over bcp?
What is an indice?
What is rolap and its advantage? : sql server analysis services, ssas
What is explicit cursors?
Can you please explain the difference between primary keys and foreign keys?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Does hive support indexing?
How can sql server instances be hidden?
Does the unique constraint create an index?
