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

What is cascading rollback?

1190

What is the function of logging in the db2 database?

1102

What is a plan and package in db2?

1086

What is a bind in db2?

1020

What is load replace in db2?

981

Explain package in db2 and its advantages?

1188

Name the various locking levels available?

1081

How to retrieve rows from a db2 table in embedded sql?

1372

How to test SQL -911 error while developing COB-DB2 program

7528

What is the purpose of rollback and commit?

1170

What is plan in cobol db2?

1112

What is drop table?

998

Before you give the explain statement, what are the prerogatives?

1012

i want to maintain uniqueness on pdf without make lf??????????

2144

What are the full forms of spufi and dclgen and why are they used?

1061