E-mail Print PDF

()

Синтаксис SQL ()

SELECT (column_name) FROM table_name

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:

1000

Comments

 
+1 #1 Шелест Константин 2010-10-28 23:28 I wonder whether it makes sense at all to find the first value ...? who znaet, type! Quote
 
 
0 #2 Шелест Константин 2010-10-28 23:33
I wonder whether it makes sense at all to find the first value ...? who znaet, type!

+ This request and I still have not plow ... sad
Quote
 
 
-1 #3 Александр123 2010-11-01 08:56 Of course it makes sense) through the order by list can be sorted and then output the first record ... the truth is another limit, which in theory should work faster, but can not sort the SQL, and stupidly returns the first record:) Quote
 
 
-1 #4 ITSELF 2010-11-02 20:42
Of course it makes sense) through the order by list can be sorted and then output the first record ... the truth is another limit, which in theory should work faster, but can not sort the SQL, and stupidly returns the first record:)

So after all, what's the point ... the first line of output?, For example, the first officer entered into the table, well, he is ... after a while it was removed,! employee who now have a second table - was the first. But he did not istenno first. That is the essence of my question!
Quote
 
 
0 #5 Иван 2011-07-05 20:31 Here's a simple example, such as you have a field code ... and you need to do a final code ... choose the data sorting in descending order, take the first ... and make him a ... Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

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

Advertisement