Highlights
All Snippets
Top 100 Snippets
Librarians
gbCodeLib

By Language
VB6
JavaScript
Perl
HTML
SQL
Java
DOS

GBIC >> Source Code >> SQL >> Snippet

03 Sample Queries


SELECT   *   FROM customers

SELECT  firstname, lastname, age   FROM customers

SELECT *   FROM  customers   WHERE NAME LIKE "%David%"

SELECT  item, price, price * 1.07 (Sale Price)   FROM inventory

SELECT *   FROM  customers   WHERE NAME LIKE "David%"

SELECT NAME   FROM customers   WHERE state = "TX" OR state = "CA"

SELECT *    FROM friends   WHERE areacode   IN (100,381,204)

SELECT *    FROM friends   WHERE areacode BETWEEN (100,200)