Difference between revisions of "Nejstarší rezervace"
From Wikivyuka
m |
m |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | SELECT TOP 1 REZERVACE.datum_rez, CTENAR.jmenoC, CTENAR.prijmeniC | + | SELECT TOP 1 REZERVACE.datum_rez, CTENAR.jmenoC, CTENAR.prijmeniC |
| − | FROM CTENAR INNER JOIN REZERVACE ON CTENAR.c_cten = REZERVACE.c_cten | + | FROM CTENAR INNER JOIN REZERVACE ON CTENAR.c_cten = REZERVACE.c_cten |
| − | ORDER BY REZERVACE.datum_rez; | + | ORDER BY REZERVACE.datum_rez; |
| + | |||
| + | [http://gis.vsb.cz/wikivyuka/index.php/Dotazy Zpět na stránku Dotazy] | ||
| + | |||
| + | [http://gis.vsb.cz/wikivyuka/index.php/%C3%9Alohy_k_procvi%C4%8Dov%C3%A1n%C3%AD_u%C4%8Diva Zpět na stránku Úlohy k procvičení] | ||
Latest revision as of 11:57, 5 December 2011
SELECT TOP 1 REZERVACE.datum_rez, CTENAR.jmenoC, CTENAR.prijmeniC FROM CTENAR INNER JOIN REZERVACE ON CTENAR.c_cten = REZERVACE.c_cten ORDER BY REZERVACE.datum_rez;
