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
- 6011 Views
- CSE, I also Faced
- E-Mail Answers
Answer Posted / gajula.lavanya
SELECT T1.NAME,T2.SAL FROM emp1 T1,emp2 T2
WHERE T1.ID=T2.ID AND T2.SAL=(SELECT MAX(SAL) FROM emp2);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the properties of a relational table?
Difference between group by clause and having clause in SQL?
Why I can not enter 0.001 second in date and time literals in ms sql server?
How to connect Azure federated root database and apply federation in entity framework?
Can you explain different types of locks in sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
What is the Difference Between Primary and Foreign Key?
Explain subquery and state its properties?
Write the SQL query to drop, truncate and delete table.
Explain what is log shipping?
Do I need a report server to run reports in my application?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Explain transaction server implicit?
Describe in brief authentication modes in sql server.
What security features are available for stored procedure?
