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
6194 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 the importance of three tier architecture?

1066

Are all views updatable ?

1132

How to connect sql server management studio express to sql server 2005 express?

1010

Explain indexing and what are the advantages of it?

999

How do you run a trace?

884

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

984

What is user-defined functions? What are the types of user-defined functions that can be created?

1015

What is a transactions?

1025

What is create statement?

927

How to modify an existing stored procedure in ms sql server?

1051

What is difference statement and preparedstatement?

960

What are trace flags and mention a few common trace flags used with sql server?

1068

How to generate create view script on an existing view?

969

How do I create a stored procedure in dbml?

985

How do I find query history in sql server?

922