In join we use ON clause rather than where clause so where is not used mos

In join, which clause in not used?

Question Posted / murtaza

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Mention what are the core components of ssrs?

330

How do I uninstall sql server 2014?

985

How do I find the port number for sql server?

1017

How to Insert multiple rows with a single insert statement?

1096

What is transaction server isolation?

1092

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1027

How do I find the size of a sql server database?

979

Explain about link server in sql server?

1112

what is the difference between delete table and truncate table commands? : Sql server database administration

1079

What is the difference between left and right outer join?

1112

What is nolock?

1035

List few advantages of stored procedure.

1026

What are distinctive joins find as a part of sql?

1000

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1346

How would we use distinct statement? What is its use?

1122