Use LIMIT 4
Thanks
- Jon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, April 30, 2007 6:10 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Need Help with SQL Statement
I have a file with the columns: StockSymbol, OptionSymbol, StockPrice
I have a file with the columns: StockSymbol, OptionSymbol, StockPrice,
StrikePrice, ExpiryDate
For each StockSymbol, ExpiryDate, I would like to list just 4 of the
records where the StrikePrice is lower than the StockPrice.
The following is close to what I want except it gives me all the
2 matches
Mail list logo