Unless you want to get a count, yes. Thank You,
Irving Duran On Tue, May 29, 2018 at 1:44 PM Chetan Khatri <chetan.opensou...@gmail.com> wrote: > 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 >>> >> >