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 Columns from a Table
How To Select Some Columns from a Table? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments":
SQL> SELECT location_id, department_name FROM DEPARTMENTS; LOCATION_ID DEPARTMENT_NAME ----------- ------------------------------ 1700 Administration 1800 Marketing 1700 Purchasing 2400 Human Resources 1500 Shipping 1400 IT 2700 Public Relations 2500 Sales 1700 Executive ......
2007-04-21, 4931👍, 0💬
Popular Posts:
How To Merge Cells in a Row? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you wan...
How To Manage Transaction Isolation Level? - Oracle DBA FAQ - Introduction to PL/SQL Transaction iso...
An application needs to load a library before it starts to run, how to code? One option is to use a ...
How do you override a defined macro? You can use the #undef preprocessor directive to undefine (over...
How To Create an Add-to-Google-Reader Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS ...