In join, which clause in not used?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Normalization and DE normalization

598


Explain transaction server auto commit?

524


how many layers of tcp/ip protocol combined of? : Sql server database administration

505


How to make conditional sum in ssrs?

128


Do you know what guidelines should be followed to help minimize deadlocks?

526






What is the contrast between sql and mysql?

582


Explain multiserver query

545


Explain in brief about Microsoft SQL server?

535


How to create a ddl trigger using "create trigger" statements?

603


What are logical/boolean operations in ms sql server?

533


What is an execution plan?

558


What is coalesce in sql server?

525


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

526


Explain rdbms?

592


What is the use of builtinadministrators group in sql server? : sql server security

519