Explain the use of the WHERE clause.

Question Posted / guest

2 Answers
5467 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain the use of the WHERE clause...

Answer / tharanath.n

you can restrict the rows returned from query by using the
where clause,a where clause contain a condition that must
be met, and it directly follows the from clause. if the
condition is true, the row meeting the condition is returned

Is This Answer Correct ?

1 Yes

0 No

Explain the use of the WHERE clause...

Answer / s

The WHERE clause only retrieves the rows based on the
predicate coded in the SQL.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB2 Interview Questions

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers RBS,

What is a buffer pool?

2 Answers

What does sqlcabc has?

0 Answers

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers IBM,

what is Static and dynamic linking

1 Answers Virtusa,

What is the physical storage length of the data types date, time, and timestamp?

0 Answers

Name the different types of Table spaces.

5 Answers IBM,

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers

why we go for SPUFI for creating tables or for sql queries?

4 Answers

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?