| Sample SQL Queries |
|
|
|
|
|
|
|
|
|
| Typical: SELECT<attribs>FROM<tables> |
||||||||
| SELECT Student.FirstN, Student.LastN, |
||||||||
| Student.MajorID |
||||||||
| FROM Student |
||||||||
| WHERE Student.S_ID= 0206125; |
||||||||
| SELECT Student.FirstN, Student.LastN |
||||||||
| FROM Student |
||||||||
| WHERE MajorID=14; |
||||||||