Re: Select, Group by and Order by clause

ksingla — Mon, 13 Apr 2009 19:31:54 GMT

I don't see any filter on eventId. Are you sure eventIds other than 540 have IP as null? Can you paste some data from your CSV showing different eventId entries?

You should be able to use order by with "select *". You need to aggregate the column when using group by and that is why "select *" with group by is usually not possible.

Thanks,
Kanwal

Select, Group by and Order by clause

DirtySanchez — Fri, 10 Apr 2009 17:24:11 GMT

Curious if anyone would know the the correct syntax for the below statement to show all event id's. The way I've written it below it only shows 540 (logon's), is there way for me to use the below code to show ALL event ID's?

"select date,time,evtid,status,username,ip from \\myserver\logs\logfile.csv where ip is not null order by date, time, evtid, status, username, ip asc

if I use the "select * statement i'm unable to use the "group by" or "order by" clause because they do not match what is in the "select" clause. Is there a way around this?

Input Formats

Re: Select, Group by and Order by clause

Select, Group by and Order by clause