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

2 Answers
6280 Views
IBM, I also Faced
E-Mail Answers

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 a corelated subquerry?

1122

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8287

Is the primary key a clustered index?

1149

Why do we use cursor?

1099

What is host variable?

1056

What is rebind in db2?

1060

What are foreign keys in db2?

1103

What is the usage of open cursor command?

1100

What os does db2 run on?

981

How to take backup of table in db2?

1074

How many databases can be created inside an instance in db2 ?

1035

Mention the various locks that are available in db2.

1039

What is copy pending and check pending in db2?

1004

What is scrollable cursor in db2?

1055

Explain various types of locks in db2?

1150