Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10225 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 dml and ddl?
Why we use join in sql?
What are commit, rollback, and savepoint?
What is a primary key? Explain
What are the disadvantages of not performing database normalization?
Write the command to remove all players named sachin from the players table.
which operator is used in query for pattern matching? : Sql dba
What are field types?
What does stand for in sql?
Write a sql select query that only returns each name only once from a table?
Explain autonomous transaction.
Can we call dml statement in function?
How do I view stored procedures?
How many joins in sql?
What is Histogram?
