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
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 different types of keys in sql?
How do you delete duplicates in sql query using rowid?
What are analytical functions in sql?
Which is better stored procedure or query?
What is the use of procedures?
What are all types of user defined functions?
What is mdf ldf and ndf?
What is union?
Name the operator which is used in the query for pattern matching?
Enlist the advantages of sql.
what are the different type of normalization? : Sql dba
What are the two characteristics of a primary key?
Does user triggers have entry for trigger with compilation errors?
What is full join?
Can delete statement be rollbacked?