Sorting

Sorting a database arranges the records in order.

A simple sort arranges the records based on the contents of one field in the database table.

A complex sort involves the software arranging the records based on 2 or more fields. It will have a primary and a secondary sort key. The data is first sorted by the primary sort key and then§ the secondary sort key is used if two or more fields have the same value.

Once the sort keys have been identified there are 2 ways of sorting data, ascending and descending.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s