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
- 9455 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandu
by using sub_str fuction we can do this
select sub_str(task_number,6) from pa_tasks.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is sqlca in db2?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
What are literals in sql server?
How many tables can a sql database have?
What is snowflake sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
what are set operators in sql? : Sql dba
What does desc stand for?
Is sql difficult?
what is the use of set statement in tsql? : Transact sql
Which is better stored procedure or query?
What are the different types of triggers?
How do I view tables in mysql?
How do I tune a sql query?
