Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


In join, which clause in not used?

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 are the advanced features in sql 2008?

2 Answers   Wipro,


what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,


What is Data model and how to prepare a data model.?

1 Answers   TCS,


How to rebuild master databse?

0 Answers  


How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,






How to create a user name in a database?

0 Answers  


What are the grouping functions?

0 Answers  


Can a trigger be created on a view?

0 Answers  


explain how to create a new schema in a database? : Sql server database administration

0 Answers  


What is bit data type?

0 Answers  


I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,


What is the significance of null value and why should we avoid permitting null values?

0 Answers  






Categories