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

Differentiate between sql temp table vs table variable?

0 Answers  

What is Primary key and foreign key? Give an example

4 Answers   TCS,

What is triggers and its types?

0 Answers  

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

What are the transaction properties?

0 Answers  




What is the difference between local and global temporary tables?

0 Answers  

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

Explain “row_number()” in sql server with an example?

0 Answers  

What is the function of inner join?

0 Answers  

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

For more SQL Server Interview Questions Click Here
Categories