hist_qry9.sql  SQL

Appendix A: SQL Scripts for Sample Queries

Output

The following output displays the first 25 rows returned by this query:

TRADING_SYMBOL    YEAR        DIVIDEND
AXZ               2005     1.581407226
AYB               2006     1.381549972
AYG               2006     0.367898983
AYI               2006     5.216678323
AYN               2006     4.028782552
AYQ               2006     3450.287281
AYS               2006     3.694855018
AYU               2006     1.271758802
AYW               2006     2.619291171
AZA               2006      2.28069406
AZG               2006     0.990853336
AZH               2006     27.14814009
AZI               2006     1.061584765
AZJ               2005     0.604295833
AZK               2005     22.93923892
AZL               2005     0.902766204
AZN               2006     1.088005743
AZO               2006     1.789226001
AZV               2006     2.247136542
AZZ               2005     0.568150577
BAK               2006     1.266999535
BAL               2005      0.68438775
BAM               2005     0.499661767
BAN               2005      5.72367411
BAR               2006     1.146197323
...




Copyright © 2005. Sybase Inc. All rights reserved. SQL

View this book as PDF