IALweb Homepage
Forum Home Forum Home > Programmazione > Programmazione > ASP-ASP.NET
  New Posts New Posts RSS Feed - valore massimo in una colonna
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


REGISTRATEVI su IALWeb forum!

Topic Closedvalore massimo in una colonna

 Post Reply Post Reply
Author
Message
techweb View Drop Down
Utente Senior
Utente Senior


Joined: 06/Lug/2002
Location: Trieste
Status: Offline
Points: 288
Direct Link To This Post Topic: valore massimo in una colonna
    Posted: 15/Lug/2002 at 14:10
come faccio a ricavare il valore massimo in una colonna di un database?
esiste un modo mi sembra con la queruy ma non so quale
Back to Top
Sponsored Links


Back to Top
zioalfredo View Drop Down
Utente Base
Utente Base


Joined: 08/Lug/2002
Location: Roma
Status: Offline
Points: 15
Direct Link To This Post Posted: 16/Lug/2002 at 15:31
SELECT MAX(NomeCampo) FROM NomeTabella
Back to Top
Guests View Drop Down
Ospite
Ospite
Direct Link To This Post Posted: 16/Lug/2002 at 16:08
SQL = "SELECT MAX(nomecampo) As Massimo FROM tabella"
set rs = Conn.Execute(SQL)

Response.Write "Il valore massimo Ŕ " &_
rs("Massimo")

rs.Close
Set rs = Nothing
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.17
Copyright ©2001-2013 Web Wiz Ltd.

This page was generated in 0,047 seconds.