|
-
Feb 3rd, 2008, 05:38 AM
#1
Thread Starter
Frenzied Member
[2008] SQL CMD get last row in a column
I want to get the last row in my colum 'ID'
such as:
Dim sqlCommand As New SqlCommand("SELECT LASTROW of ID FROM Table4")
however, LASTROW, or LAST is not exactly a valid command, basically I want to count how many entries have been added, since ID has AutoIncrement, then the value of the last row, will be the correct amount.
Can anyone tell me how to do this?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|