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

What is bit data type?

1 Answers  

What is nested transaction?

1 Answers  

What are the types of database recovery models?

1 Answers   HCL,

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1 Answers  

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

When is the use of update_statistics command?

1 Answers  

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

Do you know how to make remote connection in database?

1 Answers  

When multiple after triggers are attached to sql table, how to control the order of execution?

1 Answers  

Which sql server is best?

1 Answers  

Does partitioning ssd reduce performance?

1 Answers  

Where is localdb stored?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories