/* select all columns and all rows */ select * from student; /* select some columns and all rows */ select student_id, lname, fname from student;