SELECT Y FROM TABLEA WHERE Y LIKE 'abc%';

in column y record
abc.v
abc.s
xyz.j
abc.h
i wan only abc columns
how to retrieve thi records

Question Posted / ekalavya

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

Answer Posted / ekalavya

SELECT Y
FROM TABLEA
WHERE Y LIKE 'abc%';

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the prerogatives?

1014

What is cobol db2?

933

What does db2 mean?

955

What's The Error Code For Unique Index Voilation?

1153

What is the syntax for creating a table in the db2 database?

1058

What is explain in db2?

958

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3520

Explain correlated sub-queries.

976

What are db2 objects?

1000

What is multi row fetch in db2?

986

What is node in db2?

986

How can you quickly find out the # of rows updated after an update statement?

985

Explain package in db2 and its advantages?

1134

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2338

What does a deadlock mean in DB2?

1095