Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 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
What is co-related sub query?
What is difference between delete and truncate commands?
What are the steps to process a single select statement?
How are the exceptions handled in sql server programming?
What is 'Join' and explain its various types.
How can you list all the columns in a database?
what purpose does the model database serve? : Sql server database administration
What does it mean if @@cursor_row returns a negative number?
how to use DTS package in 2000,2005,2008 in sql server
what is the main function of a query parameter?
Why should one not prefix user stored procedures with ‘sp_’?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is the default schema of your login session in ms sql server?
How real and float literal values are rounded?
Difference between report and query parameter.
