🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: free.it.visual-basic
Article #1644

Re: Min e Max

#1644
From: Gianni
Date: Fri, 12 Mar 2004 22:42
14 lines
1368 bytes
> Si, basta usare una query per ordinare i record  :D
>
> SELECT * FROM TABELLA WHERE CAMPO=VALORE ORDER BY CAMPO ASC
>
> oppure DESC

A questo punto se usiamo sql:

SELECT min(nome_campo) FROM tabella
SELECT max(nome_campo) FROM tabella

-- 
Gianni
http://www.astice.net
Technical Details
Message-ID: <p1r4c.45411$O31.1954656@news4.tin.it>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!tiscali!newsfeed1.ip.tiscali.net!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mail
References: <Xm04c.65425$FJ6.2327641@twister1.libero.it> <c2sp0d$9ga$1@grillo.cs.interbusiness.it>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f94ee,65cb212d55355dca
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2004-03-12 14:44:08 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!tiscali!newsfeed1.ip.tiscali.net!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mail
From: "Gianni" <stojkovicNONSPAMMARE@tiscali.it>
Newsgroups: free.it.visual-basic
References: <Xm04c.65425$FJ6.2327641@twister1.libero.it> <c2sp0d$9ga$1@grillo.cs.interbusiness.it>
Subject: Re: Min e Max
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <p1r4c.45411$O31.1954656@news4.tin.it>
Date: Fri, 12 Mar 2004 22:42:29 GMT
NNTP-Posting-Host: 80.117.223.73
X-Complaints-To: newsmaster@tin.it
X-Trace: news4.tin.it 1079131349 80.117.223.73 (Fri, 12 Mar 2004 23:42:29 MET)
NNTP-Posting-Date: Fri, 12 Mar 2004 23:42:29 MET
Organization: TIN