query 2nd
-
Good day everyone, need help again. on my database i have 5 different record but they have same Venue field name... i need to get the first record that was inputed to the database and display on the screen. next, on how to display the 4 remaining records. using sql 2000
-
Good day everyone, need help again. on my database i have 5 different record but they have same Venue field name... i need to get the first record that was inputed to the database and display on the screen. next, on how to display the 4 remaining records. using sql 2000
welbert wrote:
on my database i have 5 different record but they have same Venue field name...
Do you mean that in a table you have 5 rows with the same Venue column value? I'm trying to clarify because SQL Server 2000 will not permit you to have the same column name 5 times in one table.
welbert wrote:
i need to get the first record that was inputed to the database and display on the screen.
Do you have any columns that indicate the order that the row was inserted into the table? e.g. a column representing an incrementing id, or a datetime column that represents when the data was inserted? ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?