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
10645 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

What has stored procedures in sql and how we can use it?

1129

Define implicit and explicit cursors.

1209

What is difference between hql and native sql?

1239

What is pl sql in dbms?

992

What is dml with example?

1156

How to select unique records from a table?

1111

Which is better trigger or stored procedure?

1016

Can we use view in stored procedure?

956

What is sap sql anywhere?

1169

What is the primary key?

1003

What is the current version of postgresql?

1129

Write a sql query to get the third highest salary of an employee from employee_table?

1120

What is sqlite format?

1266

How do I write a cron which will run a sql query and mail the results to agroup?

1035

Is join an inner join?

1026