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
- 9456 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 is a materialized view? : Sql dba
What are the operators in sql?
What is meaning of <> in sql?
how to escape special characters in sql statements? : Sql dba
what is the difference between char_length and length? : Sql dba
what are enums used for in mysql? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
What is the difference among union, minus and intersect?
Can a table have no primary key?
How does sql profiler work?
What are its different types of dbms?
What is pivot in sql?
What is scalar data type in pl sql?
What is pl sql and why it is used for?
How to write html code in pl sql?
