Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

hi all, input TAB1 COL1

Status
Not open for further replies.
gdg1976

gdg1976

Programmer
Sep 1, 2021
14
IT
hi all,


input
TAB1
COL1
---
AAA
BBB
CCC


How can i obtain the follow output with a SELECT maybe CASE?
TAB1
COL1
---
CCC
AAA
BBB


thanks in advance,
bye
 
Status
Not open for further replies.

Similar threads

msol25
  • Locked
  • Question
Please help me to get all users list in DB2
Replies
2
Views
265
bwleon
bwleon
msol25
  • Locked
  • Question
Please help for query list all tables in DB2 using squirrel tool
Replies
0
Views
72
msol25
msol25
Motlatjo
  • Locked
  • Question
Hi All I would like to know if i
Replies
2
Views
76
Motlatjo
Motlatjo
bitwise
  • Locked
  • Question
How to return all rows on a SUM/COUNT query?
Replies
3
Views
108
blom0344
blom0344
MarcLodge
  • Locked
  • Question
Wait All DB2 I/O
Replies
3
Views
83
MarcLodge
MarcLodge

Part and Inventory Search

Sponsor

Back
Top