# Update/select standard group **URL:** \ **Category:** Ignition\ **Created:** [January 24, 2013, 9:53am UTC](https://forum.inductiveautomation.com/t/update-select-standard-group/5735 "2013-01-24T09:53:34Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![SamJaimes](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Post date:** [January 24, 2013, 9:53am UTC](https://forum.inductiveautomation.com/t/update-select-standard-group/5735/1 "2013-01-24T09:53:34Z")
Hello! It is possible that an Standard Group can’t update last row in a SQL Server table just by selecting “last” in the update/select option? I tried it and it didn’t work, i had to specify the last row in custom option. ---
**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\ **Post date:** [January 24, 2013, 5:01pm UTC](https://forum.inductiveautomation.com/t/update-select-standard-group/5735/2 "2013-01-24T17:01:37Z")
It should work, are you getting any errors when running the group? Are you sure that the target name of your group items and the column names in the group settings (under the “Action” tab) match up with the database? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [January 24, 2013, 5:02pm UTC](https://forum.inductiveautomation.com/t/update-select-standard-group/5735/3 "2013-01-24T17:02:39Z")
Yes, you can but you have to select the right index column. So check the “Use Custom Index Column” and choose your index column. That is how we know what is the first or last row. ---
**Author:** ![SamJaimes](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Post date:** [January 28, 2013, 9:20am UTC](https://forum.inductiveautomation.com/t/update-select-standard-group/5735/4 "2013-01-28T09:20:47Z")
Thanks!