This question doesn't make any sense. Do you mean select * from

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 / student

3 Answers
9090 Views
SAP Labs, I also Faced
E-Mail Answers

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

Where to find ntwdblib.dll version 2000.80.194.0?

962

what changed between the previous version of sql server and the current version? : Sql server database administration

1015

What are the results of running this script?

933

Write an SQL query to obtain the 2nd highest salary.

1079

Can sql server be linked with other servers like oracle?

968

What is data modeling and Reterminal integrity?

1956

What is optimistic concurrency?

1040

How to connect to a sql server using odbc_connect()?

1158

What are different types of statements that are supported by sql?

1047

Can one drop a column from a table?

1021

What is difference between global temporary tables and local temporary tables?

1238

How do you set a trace flag in sql server?

1041

How to use subqueries with the exists operators in ms sql server?

1122

How can we get count of the number of records in a table?

955

What happens if null values are involved in datetime operations?

976