Write a query to genarate target column.Please answer me.
Advance Thanks.
Src Tgt
Q10 Quarter to 2010
Q90 Quarter to 1990
Q80 Quarter to 1980
Q74 Quarter to 1974
- 5 Answers
- 10620 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / ajit
select substr(src, 1,1 )||'uarter to '||to_char(to_date (substr(src, 2), 'rrrr'), 'yyyy') tgt
from <Table Name>
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is a composite primary key ? : Sql dba
Why truncate is faster than delete?
what is sub-query? : Transact sql
What is embedded sql in db2?
Explain the insert into statements in sql?
How will you distinguish a global variable with a local variable in pl/sql?
How do I send sql query results to excel?
How do I add a database to sql?
How does pl sql work?
Why is a primary key important?
What is ttitle and btitle?
What is parallel hint?
What is difference between stored procedures and application procedures?
What has stored procedures in sql and how we can use it?
What is the difference between delete and truncate statement in sql?
