Jūs esate

MSSQL. Įrašo gavimas, kurio data yra artimiausia šios dienos datai

Turime duomenis: Petras 2008.01.02 Juozapas 2009.01.05 Antanas 2001.12.01 SELECT TOP 1 Data FROM Lentelė ORDER BY ABS(DATEDIFF(DAY,GetDate(),Data)), Data Šis gėris išrinks Juozapą. Arba galima patobulinti - pridėti WHERE sąlygą, kad Data > GetDate() Čia MSSQL versija :) http://bytes.com/forum/thread79502.html

Komentarai

Playtech – Uberwin.club <a href=http://www.uberwin.club/playtech/>Click here>>></a>

Just desire to say your article is as astounding.

The clarity in your post is simply cool and i could assume you're an expert on this subject.
Well with your permission let me to grab your feed to keep up to date
with forthcoming post. Thanks a million and please
keep up the enjoyable work.

Viagra Amazon Uk https://buyciallisonline.com/# - Buy Cialis Viagra Pfizer Tabletten <a href=https://buyciallisonline.com/#>Cialis</a> Amoxicillin Rx 655

Komentuoti