SELECT T1.NAME,T2.SAL FROM emp1 T1,emp2 T2 WHERE T1.ID=T2.ID AND T2.SAL=(S

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 ?

Question Posted / gajula.lavanya

5 Answers
6202 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

Please Help Members By Posting Answers For Below Questions

How to generate create function script on an existing function?

1091

how can a database be repaired? : Sql server administration

955

What are “lock” hints?

1045

How to see the event list of an existing trigger using sys.trigger_events?

1057

What program is used to store the data source file?

942

How do I create a stored procedure in dbml?

988

Explain powershell included in sql server 2008?

1039

How do I trace a query in sql server?

933

What are pessimistic lock and optimistic lock?

1054

What is rolap and its advantage? : sql server analysis services, ssas

1260

What is the difference between a stored procedure and a user defined function?

1010

Can we take the full database backup in log shipping?

931

Which are the olap features?

940

Can you please explain the difference between primary keys and foreign keys?

1092

Explain an automatic checkpoint

961