Products Support Documentation Download
Retrieving Data from a Database

The reason data is stored in a database is so that it can be later retrieved and looked at. However, in order to do something intelligent with that data it must first intelligently be retrieved. This is often much easier to say than to do and that is particularly true with a language like SQL.

Data is retrieved from RDM databases using the SQL select statement. This section will explain how to properly formulate select statements to view data contained in one or more RDM databases.

A completely specified select statement is commonly referred to as a query. The complete set of rows that are returned by a select statement is called the result set.