[sqlite] Problem with distinct select query

Thanks for the suggestion, it works great. > R Smith > January 30, 2016 at 6:13 AM > > > > > A few ways come to mind, here's an easy one that works for me: > > > WITH RNDCAT(cat) AS ( -- CTE to list 20 random categories > SELECT DISTINCT formulas.majorcateg

[sqlite] Problem with distinct select query

On 2016/01/29 4:51 PM, Gary Baranzini wrote: > Hi, > > I have a query where I select 20 random distinct rows. > > SELECT DISTINCT formulas.pinyin, formulas.majorcategory, > majorfcategory.item_name > FROM formulas > JOIN majorfcategory ON majorfcategory.id=formulas.majorcategory > ORDER BY RANDO

[sqlite] Problem with distinct select query

Hi, I have a query where I select 20 random distinct rows. SELECT DISTINCT formulas.pinyin, formulas.majorcategory, majorfcategory.item_name FROM formulas JOIN majorfcategory ON majorfcategory.id=formulas.majorcategory ORDER BY RANDOM() LIMIT 20 Each row contains a major category id, "majorcate

[sqlite] Problem with distinct select query

Hi, I have a query where I select 20 random distinct rows. SELECT DISTINCT formulas.pinyin, formulas.majorcategory, majorfcategory.item_name FROM formulas JOIN majorfcategory ON majorfcategory.id=formulas.majorcategory ORDER BY RANDOM() LIMIT 20 Each row contains a major category id, ?majorcate