1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

In join, which clause in not used?

Question Posted / ashutosh.qa

Answers were Sorted based on User's Feedback



In join, which clause in not used?..

Answer / rajesh

All the clauses can be used.

Is This Answer Correct ?    32 Yes 3 No

In join, which clause in not used?..

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

In join, which clause in not used?..

Answer / sumit kumar mishra

Order Clause is not used in joining two tables.

Is This Answer Correct ?    13 Yes 15 No

In join, which clause in not used?..

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

Post New Answer

More SQL Server Interview Questions

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

Explain trigger and its types?

0 Answers  

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

How to recreate an existing index in ms sql server?

0 Answers  




What are a database and a data warehouse?

0 Answers  

How does a profiler work?

0 Answers  

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

How to create function with parameter in sql server?

0 Answers  

explain different types of joins? : Sql server database administration

0 Answers  

When columns are added to existing tables, what do they initially contain?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories