TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
varsha dodiya
NA
407
75.4k
sql group by clause
Aug 22 2014 2:55 AM
total
vat rs
discount %
500
5
2
1000
2
2
1200
10
5
i want my result to be calculated as
(500+5) * 2/100 =a
(1000+2)*2/100=b
(1200+10)*5/100=c
" " " " "
""""""
""
and result = SUM(a+B+C) rs.
this is what i tried
cmd = new SqlCommand("Select (SUM(P_ttotal)+SUM(P_vatto)* (P_totdis)/100) as dis from PRO_BILL", conn);
but it is throwing exception P_totdis is not in group by clause....
help me in this.
any help will be appreciated
Reply
Answers (
3
)
drawing on a panel using lineshape with vbnet 2010
Crystal Report, showing record of current day only