0

is d query rite ? q = "update FIRSTBBA WHERE FBBANAME<>"" ORDER BY FBBANAME" Need to update a table in ascending order

Harish
  • 169
  • 3
  • 5
  • 11

2 Answers2

1

This query is not complete. You can use inner SQL statement based on your requirement and update the table based on that.

PradeepGB
  • 314
  • 2
  • 10
0

You're not assigning a value to FIRSTBBA. Also, not sure what database you're using but I don't think SQL server allows an order by clause in an update statement. you would have to refer to a post like this one: How to update and order by using ms-sql

Community
  • 1
  • 1
clyc
  • 2,420
  • 14
  • 15