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's the difference between a primary key and a unique key?
How to create an index on a view?
How to delete duplicate rows?
If the job running very slow what is the action you do
How create table structure only from tableA to TableB if TableA have some data?
Why and when do stored procedure recompile?
what is statistics
What are window functions in sql server?
What are different types of Keys? Please explain all the keys with a suitable example.
What is primary key and example?
can you any body tell me suppose database is suspect mode. how can take to normal?
Can we store videos inside the sql server table?
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)