Select Some Rows from a Table in Oracle

Q

How To Select Some Rows from a Table in Oracle?

✍: 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
......

 

Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 147👍, 0💬