Member Avatar for softplussystems

Hi Guys

I Have a table with 2 fields & several roows like this :

Cd val
-- ---
a 1
b 2
c 1
d 3
f 4
g 2
h 3
k 5
l 6
m 8
n 7
o 1
p 2


I want get the result for the rows that the sun of val gives 10 for example,

The Result must a cursor or table like this:

cd val
-- ---
a 1
b 2
c 1
d 3
h 3

I wonder if it's possible to use a sql command that give this result.

Regards

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by iamthwee
Member Avatar for iamthwee

That could potentially be a lot of options.

It wouldn't be possible in just pure MySQL.

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.