现代数据库系统实用教程ch6关系数据库管理系统的数据操纵及相关SQL语句.pdfVIP

2007-9-5 2007-9-5 6.1 RDBMS 1 1 2 3 4 2007-9-5 2007-9-5 RDBMS 2 1 •—— •—— •—— 2 •—— •—— •—— 2007-9-5 2007-9-5 RDBMS 3 1 2 3/ 2007-9-5 2007-9-5 6.2 SQL r ,r ,…r … 1 2 m r ,r ,…r 1 2 m … 2007-9-5 2007-9-5 2007-9-5 2007-9-5 SQL SELECT * | colname { , colname ... } FROM tablename { , tablename ... } [ WHERE search_condition ] [ GROUP BY colname { , colname ... } [ HAVING group_condition ] ] [ ORDER BY colname [ ASC | D