used in the MySQL database, has great flexibility for selecting subsets of data from database tables. SQL's SELECT statement shows data from whole tables or any subset of them; for example ...