Member Avatar for wolverine_ramir

I have this kind of query:

select (s.t1 + s.t2 + s.t3 + s.t4 + s.t5 + s.t6 + s.t7) total
from summary s

is there a way that i could shorten the formula? my table fields are growing and i need to include them in getting the total for the values.

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by jwenting
Member Avatar for jwenting

change your database design. It's incredibly stupid to have a need for things like that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.