Interested to Buy Any Domain ? << Click Here >> for more details...
in column y record
abc.v
abc.s
xyz.j
abc.h
i wan only abc columns
how to retrieve thi records
- 2 Answers
- 6415 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhu t
select Y from <table> where substr(y,1,3) = 'abc'
we can achieve this by using substring function in sql.
SUBSTR(column-name,starting-position,length)
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Which component is used to execute the sql statements?
How can you classify the locks in db2?
What is syscat in db2?
Which isolation level provides highest data integrity?
How would you find out the total number of rows in a db2 table?
What are union and union all?
What is an instance database?
What do you mean by cursor?
What is bind plan?
Is schema the same as database?
What is meant by dclgen?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the max length of sqlca?
What is ibm db2 used for?
What is netezza database?
