How To Select Some Rows from a Table

Q

How To Select Some Rows from a Table? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements

✍: FYIcenter.com

A

If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The following select statement only returns rows that has department name starts with the letter "C":

SQL> SELECT * FROM departments 
  2  WHERE department_name LIKE 'C%';
DEPARTMENT_ID DEPARTMENT_NAME      MANAGER_ID LOCATION_ID
------------- -------------------- ---------- -----------
          130 Corporate Tax                          1700
          140 Control And Credit                     1700
          180 Construction                           1700
          190 Contracting                            1700
......

2007-04-21, 4526👍, 0💬