Help
cancel
Showing results for 
Search instead for 
Did you mean: 
Copilot Lvl 2
Message 1 of 2

Sqlite from column values to single column row values

help me how to write this query for below output.find my table data

id                      cat                           sub-cat                    sub-sub
1                      remarkable   
2                      bsorpti_upd  
3                      ntimicrobiasdfsdf
4                      remarkable                Dissolve
5                      macokinetics
6                      pharmacodynamics 
7                      pharmacodynamics          Antimicrobial 
8                      pharmacodynamics          Antimicrobial          peptite
9                      Test 
10                     ideas    
11                     Test                      biologically

I want my output as

column

Remarkable
         Dissolve 
bsorpti_upd
ntimicrobiasdfsdf
macokinetics
pharmacodynamics
        Antimicrobial
               peptite
Test
     biologically
ideas               
1 Reply
Ground Controller Lvl 2
Message 2 of 2

Re: Sqlite from column values to single column row values

SELECT cat, sub-cat FROM [TableName] ORDER BY cat ASC

As far as formatting, what app are you using to query the database?