Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Choosing all columns: select * [Table of Contents] Rearranging the order of columns

Transact-SQL User's Guide

[-] Chapter 2 Queries: Selecting Data from a Table
[-] Choosing columns: the select clause
[-] Choosing specific columns

Choosing specific columns

To select only specific columns in a table, use: 

select column_name[, column_name]... 
     from table_name

Separate column names with commas, for example:

select au_lname, au_fname
from authors

Choosing all columns: select * [Table of Contents] Rearranging the order of columns