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

How to defragment indexes with alter index ... Reorganize?

666


How does using a separate hard drive for several database objects improves performance right away?

613


What is raiseerror? What is raiseerror?

737


Explain following error properties?

636


What is sql server database?

579






what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

597


How to change the password of a login name in ms sql server?

640


How can I track the changes or identify the latest insert-update-delete from a table?

626


what is datawarehouse?

739


Is mysql the same as sql server?

591


How to delete a login name in ms sql server?

625


How to Check if table exists in sql server?

694


When cursors are useful?

653


What is user-defined function?

660


what authentication modes does sql server support? : Sql server database administration

616