Progress
SQL-92
Guide and Reference


Execute Queries Against the Table

This section contains an SQL-92 script that issues queries against the team table.

Team_que.sql
------------------------------------------------------------------------- 
-- File Name: Team_que.sql
--
-- Purpose:  Queries the team table in the y2ksports database, a copy of
--           the sports2000 database.
--
-- Requirements:
--           (1) Database must be running.               
--           (2) Team table must exist -- see Team_cre.sql
--           (3) For rows to be returned you must first populate
--               the table. See Team_upd.sql.
--           (4) Submit this script to SQL Explorer as an input file
--               (character mode) or as a run file (GUI mode).
--
-- Revision History:
-- 
-- Date                Author                     Change 
-- ----                ------                     ------
--
-- 11/99               DB-DOC                     Created, V9.1A
-------------------------------------------------------------------------

select FirstName, LastName, sport from team ;
                  
select * from team order by LastName ;
 
select * from team order by sport ; 
 
select * from team where sport like ’volleyball%’ ;

commit work ; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095