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 are the rules for db2 programming?

1102

What is the use of db2?

1061

Name the lockable units in DB2?

1133

define clustering index.

1036

What is temporal table in db2?

1048

What is the use of runstats in db2?

1116

What is a db2 schema?

1241

is it compulsory commitment control in journal?

2486

What is bind and rebind in db2?

1146

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1086

How to create backup table in db2?

1098

How do you find the maximum value in a column in db2?

1112

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11691

What is null value in db2?

1032

What is table space in db2?

1027