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
10392 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

Does sql view stored data?

938

Can a select statement fire a trigger?

1141

How do I count rows in sql?

983

what is 'mysqlimport'? : Sql dba

1019

What is synonyms?

1040

Why partition by is used in sql?

1015

What is primary key in db?

992

What are all the common sql functions?

999

Why do we use joins?

1021

how to calculate the difference between two dates? : Sql dba

1043

Why is a primary key important?

1025

Is null operator in sql?

1014

what is not null constraint? : Sql dba

1007

Explain unique key in sql.

994

what are string data types? : Sql dba

1025