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, 1815🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...