In join, which clause in not used?
Answers were Sorted based on User's Feedback
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 |
Answer / sumit kumar mishra
Order Clause is not used in joining two tables.
| Is This Answer Correct ? | 13 Yes | 15 No |
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 |
What are binary string data types in ms sql server?
how to replace double quotes by single quotes in sql server
What are the type of joins? When do we use Outer and Self joins?
How do I run a trace in sql server?
Are connections to sql server encrypted?
What are distributed partitioned views?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Differencr Between DELETE and TRUNCATE?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
Data table as parameter in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)