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

How do you load large data to the SQL server database?

2 Answers  

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

What is multi-statement table-value user-defined function?

0 Answers  

What are the parts of a function?

0 Answers  

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

what is checksum in sql server.........???

0 Answers   TCS,

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

What happens if null values are involved in datetime operations?

0 Answers  

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

What are the functions in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories