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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is nonclustered index with included columns ?

544


How to get a list of columns in a view using "sys.columns" in ms sql server?

513


Which autogrowth database setting is good?

615


What are the pre-defined functions in the sql server?

515


Can you please explain the difference between function and stored procedure?

538






How do I change my passwords (database, LDAP, and so on) without causing an outage?

594


What is log ldf?

553


How to perform backup for certificates in sql server? : sql server security

593


How to change the name of a database user?

539


What is normalization and its types?

531


explain databases and sql server databases architecture? : Sql server database administration

513


what is normalization? : Sql server database administration

522


Explain syntax for disabling triggers?

515


What is a deadlock and what is a live lock?

568


What is pivot and unpivot?

634