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
- 10216 Views
- I also Faced
- E-Mail Answers
Answer Posted / sumathy
Create table PA_TASKS ( TASK_NUMBER nvarchar (30))
Insert into PA_TASKS values ('1.1.3NN')
Insert into PA_TASKS values ('1.1.4NN')
Insert into PA_TASKS values ('1.5.1NN')
Insert into PA_TASKS values ('1.3.2NE')
Insert into PA_TASKS values ('1.5NN')
Insert into PA_TASKS values ('1NN')
Insert into PA_TASKS values ('1.2NE')
Insert into PA_TASKS values ('1CE')
Select reverse( substring(reverse (TASK_NUMBER),1,2)) from
PA_TASKS
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the most important ddl statements in sql are?
What are inbuilt functions in sql?
What is the difference between a subquery and a join?
What does the argument [or replace] do?
what is acid property in database? : Sql dba
what is the difference between group by and order by in sql? : Sql dba
What are system versioned tables?
What is mdb stand for?
Are stored procedures faster than dynamic sql?
how many ways to get the current time? : Sql dba
Sql technical questions
Why do we use partitions in sql?
Can I create table without primary key?
What is the difference between cross join and natural join?
What is the difference between nvl function, ifnull function, and isnull function?
