Collections:
Select Some Rows from a Table in Oracle
How To Select Some Rows from a Table in Oracle?
✍: FYIcenter.com
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
......
⇒ Sort the Query Output in Oracle
⇐ Select Some Columns from a Table in Oracle
2019-12-19, 3695🔥, 0💬
Popular Posts:
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a...