Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

How to find table changes in sql server?

0 Answers  

What are xml indexes?

0 Answers  

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

How to create new table with "create table" statements?

0 Answers  

whats the maximum size of view state??

0 Answers  

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

What is trigger ?

7 Answers   Cap Gemini, SQL,

For more SQL Server Interview Questions Click Here
Categories