Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 4847👍, 0💬
Popular Posts:
Are risk constant through out the project ? * Never say that risk is high through out the project. R...
What invokes a thread's run() method? After a thread is started, via its start() method of the Threa...
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...
How do you open an SSH connection to a remote box? ????
If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...