Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13491 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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What do you mean by teradata sql assistant?
Highlight all the modes that are present under Confidence Level.
Define views in teradata with syntax.
What is basic teradata query language?
Explain the term 'tables' related to relational database management system?
Is multi insert ansi standard?
What is real time and near real time data warehousing?
Explain the parallel data extension in teradata?
What is the difference between union and union all in teradata?
What is meant by a Highest Cost Plan?
What are the design features involved in teradata?
Explain teradata architecture in detail with a diagram.
What is the difference between teradata and oracle?
What do you mean by ttu in teradata?
