var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
How 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.
Did you try to use Top 1 * with Order By RowID (a primary key)
john, what's the primary key of this table?
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors