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.
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
What is a Foreign Key?
What is a db2 collection?
How many types of page locks can be held in db2?
Define db2 and its databases?
What is syscat in db2?
What is the physical storage length of timestamp data type?
Which isolation level provides maximum concurrency?
What is check constraint in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is an instance in db2?
What is innodb buffer pool?
What is rebind in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the use of db2?
What is the maximum size of a char data type in db2?