sygour

[Unit]
Description=Play ABC Lounge Radio with VLC
# On attend que le réseau soit réellement "en ligne"
After=network-online.target
Wants=network-online.target

[Service]
Type=simple
User=pi
Group=pi

sygour

-- select the nth row of a table
-- from http://stackoverflow.com/questions/16568/how-to-select-the-nth-row-in-a-sql-database-table
SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY key ASC) AS rownumber,
    columns
  FROM tablename
  WHERE condition
) AS foo
WHERE rownumber = n