Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Select Some Rows from a Table
How To Select Some Rows from a Table? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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 ......
2007-04-21, 4698👍, 0💬
Popular Posts:
How do we generate strong names ? or What is use the of SN.EXE ? or How do we apply strong names to ...
Is Session_End event supported in all session modes ? Session_End event occurs only in “Inproc mode”...
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL If you want create an ar...
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Qu...
Where Is the Submitted Form Data Stored? - PHP Script Tips - Processing Web Forms When a user submit...