SQL  Output

Appendix A: SQL Scripts for Sample Queries

tick_qry3.sql

Determine the top 10 percentage losers for the specified date on the specified exchanges sorted by percentage loss. The loss is calculated as a percentage of the last trade price of the previous day.

NoteThe SQL script setup_tick_qry3_last_price.sql should be run at the end of each trading day on the RAP cache database to capture data required by tick_qry3.sql.





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

View this book as PDF