Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10451 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
Is it possible to read/write files to-and-from PL/SQL?
What are the different dml commands in sql?
What is pivot table in sql?
Differentiate between sga and pga.
what are date and time intervals? : Sql dba
What is partition in sql query?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
How does cross join work in sql?
Can I create table without primary key?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
what are the disadvantages of mysql? : Sql dba
How do you explain an index number?
what is a trigger in mysql? : Sql dba
what are the properties and different types of sub-queries? : Sql dba
How to run sql commands in sql*plus?
