Sai Reddy

Sai Reddy

  • 1.9k
  • 214
  • 22.1k

Group by with out aggregate function

Jun 18 2018 7:50 AM
Hi,
 
The below query is working in the Mysql, how is it  possible ?
Can we expect the accurate result? 
 Where this is completely wrong in SQL Server.
Select col1,col2 from table group by col1

Answers (4)