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
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 |
Answer / srinivas(6.3)
we cn write conditions until we get exact result ,tht we need
| Is This Answer Correct ? | 3 Yes | 0 No |
Write an sql query to find the names of employees start with ‘a’?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Working with TLogs
What is the default schema of your login session in ms sql server?
What is self contained multi valued query?
What does sql server mean?
What do you understand by recursive stored procedures?
Can store procedure call by user define function in SQL server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Which tcp/ip port does sql server run on? How can it be changed?
What are the types of normalization?
Is foreign key a primary key?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)