Answers were Sorted based on User's Feedback
Answer / rajesh
All the clauses can be used.
|Is This Answer Correct ?||32 Yes||3 No|
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 the advanced features in sql 2008?
what are the main differences between ms access and sqlserver
What is Data model and how to prepare a data model.?
How to rebuild master databse?
How do you troubleshoot SQL Server if its running very slow?
How to create a user name in a database?
What are the grouping functions?
Can a trigger be created on a view?
explain how to create a new schema in a database? : Sql server database administration
What is bit data type?
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
What is the significance of null value and why should we avoid permitting null values?