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
- 8750 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
What are tables in sql?
What are all the different normalizations?
Explian rowid, rownum? What are the psoducolumns we have?
How to avoid duplicate records in a query?
Why we use joins in sql?
Can a foreign key be a duplicate?
What are the different set operators available in sql?
How can we debug in PL/SQL?
What do you mean by rowid?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How to use sql*plus built-in timers?
What do you mean by table in sql?
Does truncate require commit?
How many commands are in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
