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

What is normalisation in sql?

1041

Do stored procedures prevent sql injection?

954

How do I trace sql profiler?

954

How do rank () and dense_rank () differ?

1025

Can we alter stored procedure?

967

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

976

What is the difference between python and sql?

973

Can we use ddl statements in stored procedure?

1130

Can cursors be part of a trigger body?

1629

What is the difference between stored procedure and view?

1008

What is the mutating table and constraining table?

1010

What is union and union all keyword in sql?

1018

Can we use rowid as primary key?

966

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1027

Explain table and field in sql?

1048