What are the differences between left join and inner join in sql server?


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

Post New Answer

More SQL Server Interview Questions

Explain indexes disadvantages?

0 Answers  


One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  


what operator performs pattern matching?

2 Answers  


Display a roll having miminum marks in two subjects?

7 Answers   Patni,


What do you mean by collation recursive stored procedure?

0 Answers  


What is an active database?

0 Answers   HCL,


What are the benefits of filtered indexes?

0 Answers  


Can coalesce return null?

0 Answers  


What are the triggers in sql?

0 Answers  


SQL Server Architecture ?

0 Answers   IBM, Sapient,


What are the aggregate and scalar functions?

0 Answers  


I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  


Categories