1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

In join, which clause in not used?

Question Posted / ashutosh.qa

Answers were Sorted based on User's Feedback



In join, which clause in not used?..

Answer / rajesh

All the clauses can be used.

Is This Answer Correct ?    32 Yes 3 No

In join, which clause in not used?..

Answer / b.kumar

--Ms sql server
We can't use where clause in joins(inner/left/right/full).

Is This Answer Correct ?    0 Yes 0 No

In join, which clause in not used?..

Answer / sumit kumar mishra

Order Clause is not used in joining two tables.

Is This Answer Correct ?    13 Yes 15 No

In join, which clause in not used?..

Answer / murtaza

In join we use ON clause rather than where clause
so where is not used most probably in joins.
and order clause is also not used .

Is This Answer Correct ?    4 Yes 14 No

Post New Answer

More SQL Server Interview Questions

How to use wildcard characters in like operations in ms sql server?

0 Answers  

Is mysql better than sql server?

0 Answers  

What is the need for group functions in sql?

0 Answers  

What do you understand by recursive stored procedures?

0 Answers  

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,




Explain syntax for dropping triggers?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

Where are stored procedures in sql server?

0 Answers  

What are the approximate numeric data types?

0 Answers  

How to modify the underlying query of an existing view?

0 Answers  

Why are you getting errors when creating a new odbc dsn?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories