Select Specific Columns
Instead of *, name the columns you need.
Single Column
sql
1SELECT name FROM students;Result
| name |
|---|
| Alice |
| Bob |
| Carol |
Benefits
- Faster queries
- Less data transfer
- Clearer code

Instead of *, name the columns you need.
1SELECT name FROM students;| name |
|---|
| Alice |
| Bob |
| Carol |