how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE,
Its some urgent requirement ,thanks in advance
- 6 Answers
- 9128 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinay singh
select * from PA_TASKS pp
where pp.TASK_NUMBER in
(select QQ.TASK_NUMBER from PA_TASKS QQ
where length(trim(translate
(QQ.TASK_NUMBER,'0123456789',' '))) > 0
)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the most important ddl statements in sql?
How do you write an index?
What is the use of prepared statement?
What does joining a thread mean?
What is $$ in sql?
What is partition in sql query?
What is pl sql record in oracle?
What is compute?
What is sql key?
What is sql rowcount?
What is delimiter sql?
Can we use join in subquery?
Should I use mbr or gpt?
What are the dml statements?
Which is better trigger or stored procedure?
