Predpokladám, že
datum_montaze je nejaký dátumový typ (DATETIME, TIMESTAMP alebo DATE) a nie VARCHAR. Ak by si chcel len ID, tak:
Kód:
SELECT spz.id
FROM tbl AS spz, (
SELECT spz, MAX(datum_montaze) AS datum
FROM tbl
GROUP BY spz
) AS md
WHERE (spz.spz = md.spz AND spz.datum_montaze = md.datum)
Ak by si chcel kompletný riadok, tak:
Kód:
SELECT spz.id, md.spz, md.datum
FROM tbl AS spz, (
SELECT spz, MAX(datum_montaze) AS datum
FROM tbl
GROUP BY spz
) AS md
WHERE (spz.spz = md.spz AND spz.datum_montaze = md.datum)
Ak by ti náhodou stačila dvojica SPZ a dátum, dá sa to aj jednoduchšie:
Kód:
SELECT spz, MAX(datum_montaze) AS datum
FROM tbl
GROUP BY spz
A. S. Tanenbaum píše:
The terms LF, MF, and HF refer to low, medium, and high frequency, respectively. Clearly, when the names were assigned, nobody expected to go above 10 MHz, so the higher bands were later named the Very, Ultra, Super, Extremely, and Tremendously High Frequency bands. Beyond that there are no names, but Incredibly, Astonishingly, and Prodigiously high frequency (IHF, AHF, and PHF) would sound nice.
