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

Give the name of some fields form sqlca.

1145

What is lock escalation in db2?

1085

List out the three types of page locks that can be held.

1196

Explain db2.

1088

What is the function of logging in the db2 database?

1174

What is cloudant database?

1158

How many databases are there?

1112

What are db2 objects?

1092

Why select is not preferred in embedded sql programs?

1353

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1324

What are the benefits of using the db2 database?

1295

What is access path in db2?

1044

How to create backup table in db2?

1150

When do you specify the isolation level?

1073

What is the usage of open cursor command?

1151