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

Why stored procedure is better than query?

885

How to write pl sql program in mysql command prompt?

1007

How to add a column ‘salary’ to a table employee_details?

954

Can procedure in package be overloaded?

1029

Is nosql relational?

893

What are the different sql languages?

985

Do we need to rebuild index after truncate?

973

What is a table in a database?

991

What is normalization in sql?

962

What do you mean by rowid?

915

What is gpt format?

894

What is varray in pl sql?

1007

What's the procedure?

866

When is the explicit cursor used ?

977

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

893