how to sort rows as groups in sql

Question

I am using mysql and my rows are as follows

name   type
Alex   Bank Tranfer     
Alex   Easy 
Alex   Sec  
Alex   Easy 
Alex   Bank Tranfer     
Alex   Sec

I want the results to be like

Alex   Bank Tranfer     
Alex   Bank Tranfer 
Alex   Easy
Alex   Easy 
Alex   Sec  
Alex   Sec

GROUP BY clause get the single distinct rows.

What could be the sql for it?

I am using laravel framework if anyone knows how to do it in laravel will be appreciated.

In sort use same columns as in group. group by firstName, lastName order by firstName, lastName — Alex K., Feb 25 '17 at 21:05

score 0 · Accepted Answer · edited May 23 '17 at 12:16

The docs for Laravel query builder show only ordering by a single column:

$users = DB::table('NoOneNamesTheirTableInSQLQuestions')
                ->orderBy('name', 'asc')
                ->get();

But a quick search finds that you can repeat the orderBy() function to add more columns:

$users = DB::table('NoOneNamesTheirTableInSQLQuestions')
                ->orderBy('name', 'asc')
                ->orderBy('type', 'asc')
                ->get();

how to sort rows as groups in sql

1 Answers1