Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
- 18 Answers
- 68032 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / madhu sudhan g
select Distinct * from dbo.EMP X
INNER JOIN dbo.EMP Y ON X.salary=Y.salary
AND X.ENAME<>Y.ENAME
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the full meaning of dml?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
List the data types available in mssql?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
How can delete duplicate records in cte in sql server?
Explain the different types of joins?
List the different index configurations possible for a table?
Tell me the phases a transaction has to undergo?
How to create a stored procedure with a statement block in ms sql server?
Can you pass expressions to stored procedure parameters?
What action plan is preferred if sql server is not responding?
Do you know how to send email from database?
What the class forname () does?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How many clustered indexes there can be on table ?
