Create table PA_TASKS ( TASK_NUMBER nvarchar (30)) Insert into PA

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

Question Posted / sumathy

6 Answers
10464 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

Please Help Members By Posting Answers For Below Questions

Can we group by two columns in sql?

996

What do you understand by pl/sql packages?

1058

What is a primary key sql?

1044

what is self join and what is the requirement of self join? : Sql dba

1145

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1147

Explain the difference between rename and alias?

1010

What is index example?

1010

What are different types of queries in sql?

1121

Is t sql a programming language?

1069

Is sql a programming?

978

Can we connect to postgresql using sql developer?

1009

what is table? : Sql dba

1064

Explain spool.

1183

How does one load ebcdic data? : aql loader

1175

what are date and time functions in mysql? : Sql dba

979