E-mail Print PDF

SELECT MAX(column_name) FROM table_name

Пример SQL

O_IdOrderDateOrderPriceCustomer
1 2008/11/12 1000 Hansen
2 2008/10/23 1600 Nilsen
3 2008/09/02 700 Hansen
4 2008/09/03 300 Hansen
5 2008/08/30 2000 Jensen
6 2008/10/04 100 Nilsen

1
SELECT (OrderPrice) AS  FROM Orders

Query Result:

2000

Comments

 
+5 #1 ВАлерий 2009-12-04 19:27 If the field OrderPrice, will be of type text, but write it in numbers, from 100 and 2, selects two Quote
 
 
+6 #2 Judzhin 2010-05-11 16:16 Well then, in place of cash, you will simply write on a piece of $ 1000:) Quote
 
 
0 #3 Шелест Константин 2010-10-29 00:03
Well then, in place of cash, you will simply write on a piece of $ 1000:)

Funny))
Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement