In join, which clause in not used?

Question Posted / ashutosh.qa

4 Answers
12865 Views
HCL, NIIT, TCS, I also Faced
E-Mail Answers

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

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers

What is difference between materialized view and view?

0 Answers

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers

How to get nth highest salary from employee table.

0 Answers

How to delete duplicate rows?

0 Answers

What are indexes in sql?

1 Answers

Explain the etl (extraction, transformation, and loading)?

0 Answers

How do I view a stored procedure in sql server?

0 Answers

In which format does an image save in SQL Server database ?

0 Answers MCN Solutions,

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers

What are the advantages of partitioning?

0 Answers

What is the use of partition by in sql server?

0 Answers

For more SQL Server Interview Questions Click Here