Write a SQL queries on Self Join and Inner Join.



Write a SQL queries on Self Join and Inner Join...

Answer / Aditya Narayan

See the answer for QNO: 214607

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,


What is the osql utility?

1 Answers  


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1 Answers  


What happens when converting big values to numeric data types?

1 Answers  


What are views used for?

1 Answers  


What is a primary key?

1 Answers  


Which system tables contain information on privileges granted and privileges obtained

1 Answers  


What is the purpose of data source?

1 Answers  


Explain the use of keyword with encryption. Create a store procedure with encryption?

1 Answers  


What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,


What is attribute hierarchy? : sql server analysis services, ssas

1 Answers  


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1 Answers  


Categories