Hi Friends
I have a sql question, We have the source data as below.
101 address1, address2, address3
and the output shoulb like below
101 address1
101 address2
101 address3
Required a SQL query for this output.
Please let me know if you have any sql query for this.
Thanks in advance.
Hari M
- 6 Answers
- 11226 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / ronak
You have to use LPAD function,
Select lpad(address,20,'101')
from tableName;
NOTE: address is column name of address info, 20 is total
characters you want to display including 101 (since in this
case we don't know the characters of address),
Thank you
Ronak
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is meant by a Least Cost Plan?
What are the components provided on node?
What is dimensional modeling?
What is the purpose of using case expression in teradata?
How many tables can you join in v2r5?
In BTEQ, how are the session-mode parameters being set?
Highlight the need for Performance Tuning.
Difference between multiload and tpump?
What is called partitioned primary index (ppi)?
What is difference between user and database in teradata?
Explain fastload in teradata?
What are the string manipulation operators and functions associated with teradata?
Can we collect statistics on table level?
Can you connect multiload from ab initio?
how many modules are there in telecome domain?how to explain the architecture?
