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
Marish Balasubramanian
NA
95
10.2k
Tell Me Solun for this query
Nov 5 2012 11:59 PM
This is my query
select a.advisor_id,c.plan_Name,sum(a.premium_amount+a.carry_amount) as Business,d.target,(sum(a.premium_amount+a.carry_amount)*(d.target/100)) as Total from tbl_payment_master as a inner join tbl_user_Registration as b on a.user_Id=b.user_Id inner join tbl_planTypes as c on c.plan_Id=b.plan_Id inner join tbl_planTargets as d on d.plan_Id=c.plan_Id and d.plan_Id=b.plan_Id where a.advisor_id=2 and month(a.paid_date)=10 and year(a.paid_date)=2012 group by a.advisor_id,c.plan_Name,d.target,b.payment_Mode having (case when b.payment_Mode=1 then (((a.No_Of_Due)*1)) end)<=12
But I dont need a.no_of_due is not in group by statement how to use without groupby statement on a.no_of_due
Reply
Answers (
1
)
Sybase to SQL Server Migration(Architect Role)
sql query