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
- 9454 Views
- I also Faced
- E-Mail Answers
Answer Posted / anju hajela
select substr(task_number,-2) from pa_task;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is an alias command? : Sql dba
Can you select everything, but 1 or 2 fields, without writer's cramp?
Explain the insert into statements in sql?
What is pl sql code?
What is mutating sql table?
What has stored procedures in sql?
What are the query optimization techniques?
Can we connect to postgresql using sql developer?
What is acid property in a database?
what is oltp (online transaction processing)? : Sql dba
What is ttitle and btitle?
What is union?
What is difference between stored procedure and trigger?
How can we link a sql database to an existing android app?
what is data control language? : Sql dba
