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
- 9449 Views
- I also Faced
- E-Mail Answers
Answer Posted / sumathy
Create table PA_TASKS ( TASK_NUMBER nvarchar (30))
Insert into PA_TASKS values ('1.1.3NN')
Insert into PA_TASKS values ('1.1.4NN')
Insert into PA_TASKS values ('1.5.1NN')
Insert into PA_TASKS values ('1.3.2NE')
Insert into PA_TASKS values ('1.5NN')
Insert into PA_TASKS values ('1NN')
Insert into PA_TASKS values ('1.2NE')
Insert into PA_TASKS values ('1CE')
Select reverse( substring(reverse (TASK_NUMBER),1,2)) from
PA_TASKS
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I find duplicates in two columns?
how to drop an existing view in mysql? : Sql dba
Explain lock escalation? : Transact sql
how to decrement dates by 1 in mysql? : Sql dba
Are subqueries faster than joins?
What are the different datatypes available in PL/SQL?
What is a dirty read sql?
What company owns postgresql?
How do you create a db file?
What is an example of translating a date into julian format?
how to show all tables with 'mysql'? : Sql dba
How can you tell the difference between an index and a view?
how to use regular expression in pattern match conditions? : Sql dba
What is trigger with example?
Why procedure is used in sql?
