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

How many max. conditions can b written under the WHERE
clause?

Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))?????

Question Posted / surjit

Answers were Sorted based on User's Feedback



How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHER..

Answer / student

This question doesn't make any sense.

Do you mean

select * from table
where...
and...
and...
and...
and...
and...
and...
or..
or..
or..
or..
or..

etc.?

Is This Answer Correct ?    10 Yes 2 No

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHER..

Answer / srinivas(6.3)

we cn write conditions until we get exact result ,tht we need

Is This Answer Correct ?    3 Yes 0 No

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHER..

Answer / raj

23

Is This Answer Correct ?    6 Yes 17 No

Post New Answer

More SQL Server Interview Questions

What is sql server locking?

0 Answers  

What is the cartesian product of the table?

0 Answers  

How do you trace the traffic hitting a sql server?

0 Answers  

What is pessimistic concurrency?

0 Answers  

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

What is Self Join?

4 Answers  

what is the difference between openrowset and openquery?

0 Answers  

What is indexing and its types?

0 Answers  

select names starts with a,b,c

8 Answers   Scope International,

Explain a checkpoint?

0 Answers  

Does index speed up select statements?

0 Answers  

What is the use of sign function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories