RE: [sqlite] Need Help with SQL Statement

2007-04-30 Thread Jonathan Kahn
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, StrikeP

Re: [sqlite] Need Help with SQL Statement

2007-04-30 Thread P Kishor
see the LIMIT option On 4/30/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: 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 Sto