Hi Jay,
Thanks for your reply. I am trying the command
select * from mytable where row_id = row_id % 5
from sqlite browser and it says, no such column row_id.. Also I replaced
row_id with rowid and it gave only the first 4 records from my table. My
other concern is I will be deleting and adding records to the table. If I
want to select every nth record after such deletions and additions will the
row id not get affected?
Thanks
Uma
----- Original Message -----
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, March 27, 2006 1:56 PM
Subject: Re: [sqlite] help with sqlite command
On 3/27/06, Uma Venkataraman <[EMAIL PROTECTED]> wrote:
Hi All,
I need to be able to select the TOP N rows from a table. How do i do it =
select * from mytable limit 5
with sqlite? Also how does one select EVERY Nth row from a table?
use modulus operator for that:
select * from mytable where row_id = row_id % 5
---
On Wednesday, March 1, 2006, at a hearing on the proposed
Constitutional Amendment to prohibit gay marriage, Jamie Raskin,
professor of law at AU, was requested to testify.
At the end of his testimony, Republican Senator Nancy Jacobs said:
"Mr. Raskin, my Bible says marriage is only between a man and a woman.
What do you have to say about that?"
Raskin replied: "Senator, when you took your oath of office, you
placed your hand on the Bible and swore to uphold the Constitution.
You did not place your hand on the Constitution and swear to uphold
the Bible."
The room erupted into applause.
