in column y record
abc.v
abc.s
xyz.j
abc.h
i wan only abc columns
how to retrieve thi records
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
What is db2 and what is the use of db2 optimizer?
What is a db2 schema?
What is netezza database?
What is the difference between cursor and select statement?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the use of dclgen in db2?
List out the three types of page locks that can be held.
How does db2 sample database connect?
What is the maximum size of a char data type in db2?
What are the bind parameters ibm db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What action db2 takes when a program aborts in the middle of a transaction?
What is precompiler in db2?
What is iseries database?
What is the difference between nvl and coalesce?