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
- 9502 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
Can I learn sql in a week?
What is sql catalog?
How to prepare for oracle pl sql certification?
What are the types of join and explain each?
how to create a new table in mysql? : Sql dba
What does where 1 1 mean in sql?
How to execute a stored procedure?
What is clustered and nonclustered index in sql?
What are the ways on commenting in a pl/sql code?
What is a dirty read sql?
Can we create table inside stored procedure?
What is difference between db2 and sql?
What is pl sql block in dbms?
What is the difference between union and union all command?
Define concurrency control. : Transact sql
