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

Answer Posted / ekalavya

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

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

is it compulsory commitment control in journal?

2007

How to create db2 table in mainframe?

629

How to find the number of rows in a db2 table?

644

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

644

Why do chiropractors use drop table?

656

How can we read records for specific member in CL? AND rpg?

228

What is the usage of open cursor command?

599

What is netezza database?

570

What is the picture clause of null indicator variable?

688

Is it possible using max on a char column?

600

What is a cursor in programming?

592

When reorg is used?

668

What is db2 bind?

636

Is ibm db2 free?

571

What is precompiler in db2?

585