CODEWITHSUNDEEP
sqlasp.netoracle-database
onur
onur

Reputation: 6375

Where do I put WHERE command on complex sql command

Database admin sent me sql command for my asp.net project. But it's so hard to understand for me.

Command:

SELECT to_char(FirstDate, 'yyyymmdd') AS EXPR1, SUM(Single) AS SingleFile, SUM(Sum) AS AllFiles ROUND(SUM(SingleSize) / (1024 * 1024 * 1024), 2) AS SingleSize,
            ROUND(SUM(SumSize)/(1024 * 1024 * 1024), 2) AS SumSize
FROM (SELECT FILE, MIN(DATE) AS FirstDate, 1 AS Single, COUNT(*) AS Sum, MAX(Size) AS SingleSize, SUM(Size) AS SumSize
            FROM INETISLE.XFERLOG
            GROUP BY FILE) derivedtbl_1
GROUP BY to char(FirstDate,'yyyymmdd')
ORDER BY 1

Output like this:

EXPR1       SingleFile      SumFile         SingleSize     SumSize
19.11.2014  123123          13423           12312423       23424132

I need to link EXPR1(date) to my calendar.

Asp.net calendar control added WHERE like this:

WHERE ([EXPR1] = ?)

Where do I put this WHERE on my complex sql command?

I need to select just one day that I select on Calendar.

Upvotes: 1

Views: 91

Answers (1)

Hogan
Hogan

Reputation: 70529

SELECT to_char(IlkTarih, 'yyyymmdd') AS EXPR1, SUM(Toplam) AS ToplamDosya,     ROUND(SUM(TekilBoyut) / (1024 * 1024 * 1024), 2) AS TekilBoyut,
            ROUND(SUM(ToplamBoyut)/(1024 * 1024 * 1024), 2) AS ToplamBoyut
FROM (SELECT DOSYA, MIN(TARIH) AS IlkTarih, 1 AS Tekil, COUNT(*) AS Toplam, MAX(BOYUT) AS TekilBoyut, SUM(BOYUT) AS ToplamBoyut
            FROM INETISLE.XFERLOG
            WHERE DATE(TARIH) = ?
            GROUP BY DOSYA) derivedtbl_1
GROUP BY to char(IlkTarih,'yyyymmdd')
ORDER BY 1

Upvotes: 1

Related Questions