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
6443 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

Explain comment on transactions?

1041

What is cursors?

1259

How use inner join in sql server?

1186

What are date and time data types in ms sql server?

1158

What is role playing dimension with two examples? : sql server analysis services, ssas

1052

What is tempdb database? : SQL Server Architecture

1254

Explain what is analysis service repository?

1046

Which Model uses the SET concept

1040

Give a example to search fr a string in all stored procedure in sql server.

1059

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1028

Tell me in brief how sql server enhances scalability of the database system?

1040

What is normalization and denormalization in sql server?

1060

Can you move the resources after pausing the node? : sql server database administration

1162

what are the disadvantages of cursors? : Sql server database administration

1078

What is difference between view and materialized view?

985