Exercise: Choose Columns
Select only name, course, and marks from students.
Solution
sql
1SELECT name, course, marks FROM students;With WHERE
sql
1SELECT name, marks
2FROM students
3WHERE course = 'Python';
Select only name, course, and marks from students.
1SELECT name, course, marks FROM students;1SELECT name, marks
2FROM students
3WHERE course = 'Python';