-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Ñîðòèðîâêà çíà÷åíèé â ïîëå ñî ñïèñêîì

Âòîðíèê, 20 Ìàÿ 2014 ã. 17:37 + â öèòàòíèê
Èìååòñÿ ñâîáîäíîå ïîëå ñ âûïàäàþùèì ñïèñêîì êàôåäð â êîòîðîì äîáàâëåíà ñòðîêà "ÂÑÅ"
SELECT   0 as ID, '<ÂÑÅ>' as Êàôåäðà FROM Êàôåäðû UNION SELECT DISTINCTROW Êàôåäðû.Êîä, Êàôåäðû.Êàôåäðà FROM Êàôåäðû;

Êàê ñäåëàòü ñîðòèðîâêó? Ïðîáóþ ñëåäóþùåå è ïðîïàäàåò âîîáùå ñïèñîê èç ýëåìåíòà óïðàâëåíèÿ((.

SELECT   0 as ID, '<ÂÑÅ>' as Êàôåäðà FROM Êàôåäðû UNION SELECT DISTINCTROW Êàôåäðû.Êîä, Êàôåäðû.Êàôåäðà FROM Êàôåäðû
ORDER BY Êàôåäðû.Êàôåäðà;

http://www.sql.ru/forum/1095707/sortirovka-znacheniy-v-pole-so-spiskom


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó