select * from PA_TASKS pp where pp.TASK_NUMBER in (select QQ.TASK

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

Question Posted / vinay singh

6 Answers
10204 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

Please Help Members By Posting Answers For Below Questions

What is t sql in sql server?

997

Who is the owner of mysql database?

999

What is an intersect?

1041

Why do we need view in sql?

931

what is row? : Sql dba

1162

How to return multiple rows from the stored procedure?

912

Which language is used in sql?

986

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

930

Can there be 2 primary keys in a table?

951

Is trigger a stored procedure?

883

what are properties of a transaction? : Sql dba

1014

What is the difference between null value, zero, and blank space?

1133

What is pl sql package?

990

does sql support programming? : Sql dba

989

Does sql backup shrink transaction log?

911