Georg, I just want to double check that someone wrote MSSQL Server script where it's groupby all columns. What is alternate best way to do distinct all columns ?
On Wed, May 30, 2018 at 12:08 AM, Georg Heiler <georg.kf.hei...@gmail.com> wrote: > Why do you group if you do not want to aggregate? > Isn't this the same as select distinct? > > Chetan Khatri <chetan.opensou...@gmail.com> schrieb am Di., 29. Mai 2018 > um 20:21 Uhr: > >> All, >> >> I have scenario like this in MSSQL Server SQL where i need to do groupBy >> without Agg function: >> >> Pseudocode: >> >> >> select m.student_id, m.student_name, m.student_std, m.student_group, >> m.student_d >> ob from student as m inner join general_register g on m.student_id = >> g.student_i >> d group by m.student_id, m.student_name, m.student_std, m.student_group, >> m.student_dob >> >> I tried to doing in spark but i am not able to get Dataframe as return >> value, how this kind of things could be done in Spark. >> >> Thanks >> >