I have a table with column name 'CallType' calltype contains 5 repeatable records like'Internal','Hang Up','Wrong Queue' how to get column vales in place of column namelike once i execute the query i should be able to see in this wayInternal, Hang up, Wrong queue, and so on 10 12 13 4 5 7--------------------------------- 14 17 20thanks in advance

  • Interview Candidate
  • 3
  • 2930

Showing Answers 1 - 3 of 3 Answers

Anil Kumar

  • Dec 11th, 2019
 

We can use listtag for such scenario.

Code
  1. Internal

    2. 

  2. Hang Up

    3. 

  3. Wrong Queue

    4. 

  4. Wrong Step

    5. 

  5. Hang ON

    6. 

  6. Hang Up

    7. 

  7. Wrong Queue

    8. 

  8. Wrong Step

    9. 

  9. Hang ON

    10. 

  10. Internal

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions