[ic] SQL Statements

Jonathan Clark interchange-users@interchange.redhat.com
Thu Nov 29 11:51:01 2001


> I have seen both version of the following 2 lines, is there a difference ?
> The fields that are named in the first line are also the ones which are 
> in the output list - 
> 
> select sku, description, price from products where price < '50.00'
> select * from products where price < '50.00' 

SELECT * just means 'please return all fields'

Jonathan
Webmaint.