MIS 325 Lecture Notes - Lecture 7: Result Set

• School: UT-Austin
• Department: Management Information Systems
• Course: MIS 325
• Professor: Ayvaci

Document Summary

Works similarly to a column in a table, but can only be used to select data. Where rownum or = number: limits number of rows in result set. Sorting result set before using rownum with subquery: from (select columns from table order by column desc) Subquery: a select statement within another statement. Comparison operators: use in the search condition of a where clause. String and date literals must be enclosed in quotes. Compound condition: combining two or more search conditions. You can use parentheses to override the order of precedence. Value of the test expression is compared with the list of expressions in the. Between: where column between value and value. Like: retrieves rows that match a string pattern (mask) %: matches any string of zero or more characters. Test for null values: where column is null. Sorting by alphabetical sequence: order by lower column. You can order by alias, expression, or column position.