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

Can you insert NULL in unique column?

0 Answers   MCN Solutions,

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

What is difference between materialized view and view?

0 Answers  

How many ways to create table-valued functions?

0 Answers  

What is read uncmmited?

0 Answers  

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

How do use Having,Group by,Group function in SQL?

0 Answers  

How get current date in SQL server 2000

6 Answers   Cap Gemini,

Does partitioning help performance?

0 Answers  

Explain transaction server distributed transaction?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories