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 is log in sql server?
Is the primary key column of a table an index in ms sql server?
What is 'Join' and explain its various types.
What is the use of commit?
Why I am getting this error when renaming a database in ms sql server?
Do you know the cursor optimization tips?
What is the temp table?
What is the recovery model?
How many categories of data types used by sql server?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What is autocommit mode in sql server?
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
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)