Menu
Let's say I have this table:
id colorName
1 red
2 blue
3 red
4 blue
How can I select one representative of each color?
Result:
1 red
2 blue
676
You can use row_number() to get the row number of the row. It uses the over command - the partition by clause specifies when to restart the numbering and the order by selects what to order the row number on.
While the table name is selected type CTRL + 3 and you will notice that the query will run and will return a single row as a resultset. Now developer just has to select the table name and click on CTRL + 3 or your preferred shortcut key and you will be able to see a single row from your table.
Not random representatives, but...
select color, min(id) from mytable group by color; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
