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))?????

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 many ways to create table-valued functions?

0 Answers  


How does clustered and non clustered index work?

0 Answers  


Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  


Can you explain various data region available in ssrs with their use?

0 Answers  


How to delete existing rows in a table?

0 Answers  






Does index slows down insert statements?

0 Answers  


whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,


Define compound operators?

0 Answers  


what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  


How many types of functions are there in sql server?

0 Answers  


What is database black box testing?

0 Answers  


How do you send email on SQL Server?

0 Answers   MindCracker,


Categories