[SQL] Which SQL query makes it possible to optain the 3 greatest values of an interger list ?

ery makes it possible to obtain Result from Table ? We certainly need to use sub-queries, but how ? Thank you in advance for your help ! Yoann AUBINEAU ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropri

Re: [SQL] How do I extract ONE particular field, when multiple table contain the same field name?

the queries - write the fields in lower case - write the first lettre of a table name in upper, the rest in lower case - use a "_ID" suffixe to the field name when it correspond to the primary key of another table - name "ID" the primary key of a table I w

[SQL] Number the lines

how can I number the result's lines of a sql query ? explaination : I have a query which return me a list of values. I need to order them (it's ok, easy ;) and then number the lines. The goal is then to extract, for example, "the third maximum value". T