In SQl Sever the query would be: select substring (reverse(task

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 / samiksha

6 Answers
10724 Views
I also Faced
E-Mail Answers

Answer Posted / samiksha

In SQl Sever the query would be:

select substring (reverse(task_number),1, 2) from task

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2089

what is dbms? : Sql dba

1061

Does group by remove duplicates?

1112

Can delete statement be rollbacked?

1050

What is the current version of sql?

1091

how to escape special characters in sql statements? : Sql dba

1110

Can we use distinct and group by together?

1131

what is schema? : Sql dba

1137

Is inner join faster than left join?

1273

how many tables will create when we create table, what are they? : Sql dba

1140

what are the advantages of sql ? : Sql dba

1138

What is the current version of postgresql?

1170

define sql insert statement ? : Sql dba

1094

How do I remove duplicates in two columns?

1178

If a cursor is open, how can we find in a pl/sql block?

1235