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
Nel
NA
716
1.1m
Problem with the sql query
Apr 25 2012 6:20 AM
Hi,
I have this query:
SELECT NALOG1.GBRV, NALOG1.DATA, Min(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]) And ([NALOG1].[POCKM]>0) And ([NALOG1.GBRV] Between [@gbr1] And [@gbr2]),[NALOG1.POCKM],Null)) AS pockm, Max(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]) And ([NALOG1.GBRV] Between [@gbr1] And [@gbr2]),[NALOG1.KRAJKM],Null)) AS krajkm, [krajkm]-[pockm] AS Razlika, Max(NOVI.DATAP) AS MaxOfDATAP, Max(NOVI.DATAS) AS MaxOfDATAS
FROM NALOG1 INNER JOIN NOVI ON NALOG1.GBRV = NOVI.GBR
GROUP BY NALOG1.GBRV, NALOG1.DATA, [krajkm]-[pockm]
HAVING (((NALOG1.GBRV)="1001"))
ORDER BY NALOG1.DATA;
and as a result I get:
GBRV
DATA
pockm
krajkm
Razlika
MaxOfDATAP
MaxOfDATAS
1001
07.10.2011
43208
43293
85
27.09.2011
1001
07.10.2011
43107
43394
287
27.09.2011
1001
08.10.2011
43394
43477
83
27.09.2011
1001
08.10.2011
43477
43580
103
27.09.2011
1001
10.10.2011
43679
43766
87
27.09.2011
1001
10.10.2011
43580
43679
99
27.09.2011
1001
10.10.2011
43766
43867
101
27.09.2011
but I want to have one row for every date. For example for DATA=08.10.2011 instead of
GBRV DATA pockm krajkm Razlika MaxOfDATAP MaxOfDATAS
1001 08.10.2011 43394 43477 83 27.09.2011
1001 08.10.2011 43477 43580 103 27.09.2011
I want to have :
GBRV DATA pockm krajkm Razlika MaxOfDATAP MaxOfDATAS
1001 08.10.2011 43394 43580 83 27.09.2011
Could anybody help me please? Thanks very much in advance.
Reply
Answers (
1
)
Creating a table with custom field columns
Attendance query Required?