Select statements.....very use full..

1.select single from database into internal table

2. select fields from data base into internal table

3.select * from data bade table into internal table

4.select fields from data base table into corresponding fields into

internal table

5.select single field from data base into internal table
endselcet.

6.select fields from data base table into internal table upto N ROWS

7.select field from data base into variable like v_matnr