SELECT NAME FROM EMP WHERE NAME LIKE 'C%';

Generally if I want to select the names starting with c I
need to use c%
But how could I code to select the data which contains %
as a part of data.

Question Posted / prachi

5 Answers
7736 Views
I also Faced
E-Mail Answers

Answer Posted / prachi

SELECT NAME FROM EMP WHERE NAME LIKE 'C%';

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about rct in db2?

1043

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3145

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

1030

What is cursor stability in db2?

1277

What is schema in db2?

962

What is dbrm? What it contains? When it will be created?

992

What is the difference between dbm cfg and db cfg file in db2 ?

1478

What is a db2 cursor?

1005

What is a storage group (stogroup)?

1189

What is meant by explain?

1062

What is null indicator in db2?

1051

What is scrollable cursor in db2?

996

what is the role of the cursor in db2?

1000

What is phantom read in db2?

1071

Discuss about db2 bind?

1049