Databases Reference
In-Depth Information
When we ask for a column to be sorted, we normally check
the
Show
checkbox, but this is not necessary.
Showing a Column
We check the
Show
checkbox so that we can see the column in the results.
Sometimes, we may just want to apply a criterion on a column and not include it
in the resulting page. Here we add the phone field, ask for a sort on it, and choose
to show both the name and phone number. We also ask for a sort on the name in
ascending order. The sort will be done first by name, and then by phone number if
the names are identical. This is because the name is in a column criterion to the left of
the phone column and thus has a higher priority:
Updating the Query
At any point, we can click the
Update
Query
button to see the progress of our generated
query. We surely have to click it at least once before executing the query. For now, let's
click it and see the query generated in the query area. In the following examples, we will
click
Update Query
after each modification:
Search WWH ::
Custom Search