1. Select * from <Table Name> ---> It will select all rows from the table.
2. Select <Column Name1>, <Column Name2 from <Table Name> ---> It will select all rows of column1 and column2.
3. Select <Column Name1>, <Column Name2> from <Table Name> where <Column Name>="Value" ---> It will select data which mathes with given value.
4. Select <Column Name1>, <Column Name2> from <Table Name> where <Column Name> IN ("value1", "value2", "value3")
5. Select <Column Name> from <Table Name> where <column Name1>="value1" AND <Column Name2>="value2"
|
