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
How does cross join work in sql?
Explain cursor types?
Which tcp/ip port does sql server run?
What is a data manipulation language?
What is trigger types in sql?
Can we create a trigger on view?
how to get a list of all tables in a database? : Sql dba
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Is subquery faster than join?
How do you select unique values in sql?
Do we need to create index on primary key?
What are the packages in pl sql?
What are all different types of collation sensitivity?
what is the use of double ampersand (&&) in sql queries?
What is AUTH_ID and AUTH_USER in pl/sql ?