SELECT Statement introduction



  • SELECT statement is an elegant, flexible and highly extensible mechanism created to retrieve information from DB.

  • SQL SELECT statement is encapsulated in simple English format.

  • It is used to extract data from database, using select we can restrict the columns that are to be displayed.

  • SELECT statement does not change the data stored in DB, It will pulled out of the DB and displayed.

  • It show raw information, but also to edit information before it displayed.
  • It can sort row of data according to the date, time, text and numeric value
Previous
Next Post »