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

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

Can sql server 2016 run on windows 7?

0 Answers  

What is the difference between a Application Server and a Database

3 Answers   Oracle,

What is a with(nolock)?

0 Answers  

What is similarity and difference between truncate and delete in sql?

0 Answers  

What are the disadvantages of primary key and foreign key in SQL?

0 Answers   Alcatel-Lucent,

Do you know concepts and capabilities of sql server?

0 Answers  

How to modify an existing stored procedure in ms sql server?

0 Answers  

What is data modification?

0 Answers  

What is table value parameters (tvp)?

0 Answers  

What is ddl and dml commands?

0 Answers  

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

2 Answers   IBM,

For more SQL Server Interview Questions Click Here
Categories