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

What are the system database in sql server 2008?

0 Answers  


What is a group function explain with an example?

0 Answers  


How to get the definition of a stored procedure back?

0 Answers  


Explain the working of sql privileges?

0 Answers  


explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,






How to Insert multiple rows with a single insert statement?

0 Answers  


How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,


How many instances per computer are there in sql server 2000?

0 Answers  


Mention the differences between local and global temporary tables.

0 Answers  


How do clustered indexes store data?

0 Answers  


How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,


what are cursors? : Sql server database administration

0 Answers  


Categories