Can any one let me know as how can I query the first occurence of a record. I need to select all distinct Order Types from a table. If there is more than one record with the same Order Type, then I need to get the first record.
It would be a great help to me.
Thanks,
JohnHow do you determine which one is the first record ?|||I mean any randon first record. I used min (rowid) but it did not work.
Please help me out.
John|||Did you try to use Top 1 * with Order By RowID (a primary key)|||john, what's the primary key of this table?
没有评论:
发表评论