ITM 500 Lecture Notes - Lecture 2: James To, Sorting, Binary Number
Document Summary
Where it retrieves info from every row (of the student"s information) to see if the action meets the condition (where stdssn = 234567890") hardcoding a value this query will only work with this number. Character string is limited to character letters and a value. Select * from student where stdname = james". To figure out how to find what the student"s major is for ex. You can just click on the student"s profile, making a manual check: problem that can arise: if the query is inputted incorrectly. 3 condition"s scenarios (where [stdmajor = itm" or stdmajor = fin") and under in no brackets and stdgpa = >3: 2 possible evaluations: one combination is an and". Another combination is an or": does the qualifications apply to both the itm aspect and/or the fin aspect, and done before or, doesn"t matter for the order.