Define various ways in which SELECT statement can be used for record selection Technology?
SELECT gives you control over a number of aspects for record retrieval:
1) Which table to use
2) Which columns to display from the table
3) What names to give the columns?
4) Which rows to retrieve from the table?
5) How to sort the rows