课题_天蝎机柜服务器技术规范25版.pptVIP

天蝎机柜服务器技术规范2.5版 After completing this lesson, you should be able to do the following: Limit the rows that are retrieved by a query Sort the rows that are retrieved by a query Use ampersand substitution in iSQL*Plus to restrict and sort output at run time Objectives Limiting Rows Using a Selection “retrieve allemployees in department 90” EMPLOYEES … Restrict the rows that are returned by using the WHERE clause: The WHERE clause follows the FROM clause. Limiting the Rows That Are Selected SELECT *|{[DISTINCT] column|expression [alias],...} FROM table [WHERE condition(s)]; SELECT employee_i