CSCI 183 Lecture Notes - Lecture 10: Null (Sql), Microsoft Powerpoint
Document Summary
Lecture, reading/chapter/novel/article during class, power point, movies (if need to collect info. ) Sql order by: used to sort the result-set in ascending or. Sql null values descending order: sorts the records in ascending order by default, desc keyword sorts the records in descending order. Order by column1, column2, asc|desc: order by, order by desc, order by several columns, used to insert new records in a table. Or if adding values for all the columns of the table, you do not need to specify the column names in sql query. Where column_name is null: is not null: Where column_name is not null: is null, is not null, used to modify the existing records in a table. Set column1 = value1, column2 = value2, Where condition: update, update multiple records, warning: if where is missing, then all records will be updated. Statement: used to delete existing records in a table.