SQL  Output

Appendix A: SQL Scripts for Sample Queries

hist_qry6.sql

(Based on the previous query) Find the points (specific days) when the 5-day moving average intersects the 21-day moving average for these stocks. Output is sorted by TRADING_SYMBOL and trade date.





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

View this book as PDF