DIV | AC_CD | AC_SH_DESC | AC_DESC |
1 | 74115 | abc | cef |
3 | 74115 | abc | cef |
I have div field in my table i want to create a query which can concate div field and AC_CD must be distinct.
output i want.
DIV | AC_CD | AC_SH_DESC | AC_DESC |
1/3 | 74115 | abc | cef |
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Try the below query:
Chaitanya
Thank You Vinish