--BY USING MS SQL SERVER SELECT TOP 1 * FROM (SELECT DISTINCT TOP 1 #A

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 / b.kumar

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

Answer Posted / b.kumar

--BY USING MS SQL SERVER

SELECT TOP 1 * FROM
(SELECT DISTINCT TOP 1 #A.ID,#A.NAME,#B.SAL
FROM #A INNER JOIN #B ON #A.ID=#B.ID ORDER BY SAL) E
ORDER BY SAL

--HERE #A, #B ARE TEMP TABLES
--E IS ALIAS NAME

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to perform key word search in tables?

963

What is scrollable cursor?

1044

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

1074

Define self join?

1035

Can you name some of the dml commands in sql?

1034

What is the difference between delete and truncate statements?

1084

What stored procedure can you use to display the current processes?

895

What is a transactions?

1042

what is spatial nonclustered index

994

What is cube dimension? : sql server analysis services, ssas

1010

How to select true false based on column value in sql server?

1036

How can we check the sql server version?

1073

What is Dependency Injection and provide example?

1122

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

908

What is the downside of using udf?

1109