SELECT name,min(sal) from emp1 inner join empsal where emp1.id=empsal.id

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 / ramnath_445

5 Answers
6013 Views
CSE, I also Faced
E-Mail Answers

Answer Posted / ramnath_445

SELECT name,min(sal) from emp1 inner join empsal where emp1.id=empsal.id

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is co-related sub query?

978

What is difference between delete and truncate commands?

997

What are the steps to process a single select statement?

889

How are the exceptions handled in sql server programming?

999

What is 'Join' and explain its various types.

1067

How can you list all the columns in a database?

887

what purpose does the model database serve? : Sql server database administration

924

What does it mean if @@cursor_row returns a negative number?

943

how to use DTS package in 2000,2005,2008 in sql server

1788

what is the main function of a query parameter?

140

Why should one not prefix user stored procedures with ‘sp_’?

987

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1072

What is the default schema of your login session in ms sql server?

996

How real and float literal values are rounded?

1096

Difference between report and query parameter.

1026