Comments by kparun86 (Top 15 by date)

Alright how to pass the values to this function?

Yep Now it s working. I Guess i made some mistake . now it s working fine thanks :)

Nope it s not working. May i know why u have included sum (nvalue) in the query. actually i dont need to sum any n values.

Ok Thanks Sandeep.

Nope it s not working. i ll try in other ways i can.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

I'M GETTING TAT ERROR.

HI CENARJUN. I KNOW TAT WAY. BUT I DONT NEED ALL THE INGREDIENTS WHICH HAVE N VALUE AS ZERO. WAT I NEED IS FOR INGREDIENT 2 AND 4 ALL THE VALUES ARE ZERO. I NEED OLY THAT PARTICULAR INGREDIENT ID WHERE ALL THE N VALUE ARE ZERO. IF I WRITE THE ABOVE QUERY I LL EVEN GET 1 AND 3 ALSO IN TAT LIST.

Thanks Solution 2 is working.

ok fine. thanks

Continuity in the sense we want a total count of how many data's are there. thats why i wanted to update it like that.

Ok fine. i have a huge database which is containing 60,000 datas. We may delete few datas and update few data. we have to maintain the continuity in the serial no column. Thats why i want to update like that.

Ok fine. i have a huge database which is containing 60,000 datas. We may delete few datas and update few data. we have to maintain the continuity in the serial no column. Thats why i want to update like that.

OK will try that.