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

application server is slow what may be the problem

2230

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

986

What are unicode character string data types in ms sql server?

1265

What is the current pricing model of SQL Azure?

104

Explain foreign key in sql server?

1035

What is query parameter in ssrs?

163

Is sql different from sql server?

1097

Explain about SQL server 2005?

983

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

979

Why do we use non clustered index?

1091

How to enter comments in transact-sql statements?

951

What is 'Join' and explain its various types.

1144

What can be used instead of trigger?

1162

When to use null data driven subscription?

209

Is sql server a database?

1006