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

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 is the purpose of rollback and commit?

677


What does db2 stand for?

671


Which command is used to connect to a database in DB2 ? Give the Syntax.

688


What is the use of db2 optimizer?

692


What does runstats do in db2?

689






How do I start db2 in windows?

656


What is database manager in db2?

635


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1896


How do you eliminate duplicate values in db2?

795


How to take backup of table in db2?

669


How many databases are there?

667


What is explain plan in db2?

671


How do I add a column in db2?

672


What is blu acceleration in db2?

693


How do you simulate the explain of an embedded sql statement in spufi/qmf?

723