What is inner join? Explain with an example?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is a scheduled job or what is a scheduled task?

0 Answers  


What is database white box testing?

0 Answers  


When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,


What is the order by used for?

0 Answers  


Which language is supported by sql server?

0 Answers  






What is surrogate key? : sql server analysis services, ssas

0 Answers  


I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,


How to update multiple rows with one update statement in ms sql server?

0 Answers  


New concepts of sql server 2005 use in your project.

0 Answers   TCS,


How to list all tables having unique constraints in any of the columns in a database.

1 Answers  


Can two tables have the same primary key?

0 Answers  


What happens to a trigger with multiple affected rows?

0 Answers  


Categories