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

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

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

 

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

 -Ñòàòèñòèêà

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


Ïðåäïîñëåäíÿÿ çàïèñü

Ïÿòíèöà, 20 Èþëÿ 2018 ã. 08:31 + â öèòàòíèê
Äîáðûé äåíü. Î÷åíü íóæíà âàøà ïîìîùü. Íåîáõîäèìî äîñòàòü ïðåäïîñëåäíþþ çàïèñü. Àíàëîã ïðèìåðà ÿ íàøëà, íî òàê êàê ÿ ýêîíîìèñò, òî ñ sql âñå ïëîõî. Çàðàíåå ñïàñèáî.
SELECT Ñ2.Òàáíîìåð, Ñ1.ÔÈÎ, Ñ2.Äàòàíàçíà÷åíèÿ, Ñ2.Äîëæíîñòü, Ñ2.Îòäåë, Ñ2.Êàòåãîðèÿ, Ñ2.Äîëæíïðîôø, Ñ2.Íîìåðïðèêàçà
FROM Ñ1 INNER JOIN Ñ2 ON Ñ1.Òàáíîìåð = Ñ2.Òàáíîìåð
WHERE (((Ñ2.Äàòàíàçíà÷åíèÿ) Is Not Null) AND ((Ñ2.[Äàòàíàçíà÷åíèÿ])<[Forms]![Äàííûå ÎÊ]![Íà÷àëüíàÿÄàòà]));


âîò ïðèìåð
where Äàòà_äîáàâëåíèÿ = (select max(Äàòà_äîáàâëåíèÿ) from tab where Äàòà_äîáàâëåíèÿ < (select max(Äàòà_äîáàâëåíèÿ) from tab))


Ìîÿ äàòàíàçíà÷åíèÿ. Äåëàëà ïî àíàëîãèè, íî ðóãàåòñÿ, à ïîíÿòü â ÷åì âîïðîñ, íî íå ìîãó.

http://www.sql.ru/forum/1299114/predposlednyaya-zapis


 

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

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

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

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