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
- 6453 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 a with(nolock)?
What is user defined datatypes and when you should go for them?
What is transact-sql language?
What is a dataset and what are the different types of datasets?
How can you stop stored procedures from recompiling?
Can you use order by when defining a view?
What is sub-query in sql server?
Do you know what are various aggregate functions that are available?
How you can move data or databases between servers and databases in sql server?
What is difference between index seek vs. Index scan?
How retrieve field names from the table in SQL through JAVA code?
What are cascading parameters in ssrs reports?
Explain various data region available in ssrs with their use?
What are the advantages of using stored procedures?
What are the tools available in market as an alternative to sql server reporting services?
