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 ?
- 5 Answers
- 4857 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
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the purposes of floor and sign functions?
Does union all remove duplicates?
How to bind a view to the schema of the underlying tables?
What is the concept of optimization?
If the job running very slow what is the action you do
Write a program using SQL queries to find a unique entry in a table.
What is the purpose of sql profiler in sql server?
What are the types of normalization?
Some queries related to SQL
Find first and last day of current month in sql server
List down some advantages of sql stored procedure?
Do you know spatial data types - geometry and geography in sql server 2008?
How do you start single user mode in clustered installations?
What is a view and what are its advantages?
