Content deleted Content added
Fjerdingen (talk | contribs) →Method with filter (it is more sophisticated but necessary for very big dataset): Add Mimer SQL to list |
Fjerdingen (talk | contribs) →Overview: remove the "syntactic sugar" part. DISTINCT makes full sense, (As in many cases you can achieve the same result in many ways. Here using UNION, GROUP BY and others.) |
||
Line 56:
| quote = [...] the keyword DISTINCT [...] eliminates the duplicates from the result set.
}}
</ref>
The following example of a <code>SELECT</code> query returns a list of expensive books. The query retrieves all rows from the ''Book'' table in which the ''price'' column contains a value greater than 100.00. The result is sorted in ascending order by ''title''. The asterisk (*) in the ''select list'' indicates that all columns of the ''Book'' table should be included in the result set.
| |||