CSCI 183 Lecture Notes - Lecture 9: Semicolon, W3Schools
Document Summary
Lecture, reading/chapter/novel/article during class, power point, movies (if need to collect info. ) Sql statement in database systems that allow more than one sql statement to be executed in the same call to the server. Sql select: select data from a database. From table_name: select all the fields available in the table. Select * from table_name: select, select * from, used to return only distinct (different) values. From table_name: select distinct, select count, used to filter records, used to extract only those records that fulfill a specified condition. Where condition: sql where //required single quotes, select where (numeric) //no single quotes for numbers. Sql and, or, not: where can be combined with and, or, and. Not operators: the and operator displays a record if all the conditions separated by and are true. Where condition1 and condition2 and condition3 : and, the or operator displays a record if any of the conditions separated by or is true.