MySQL: Show all rows with same column value one after the other with the column value appearing only once -


i have table columns:

resourceid | reason 

i have 4 rows values follows

2884 | irrelevant 3441 | irrelevant 2884 | incorrect 1234 | incorrect 

i want data appear this:-

2884 | irrelevant      | incorrect 3441 | irrelevant 1234 | incorrect 

i.e. want rows similar resourceid appear group want display resourceid first row. how can write query this?


Comments

Popular posts from this blog

php - Embed BBCode within itself not working -

three.js - how to load gltf in three JS -

sql server - T-SQL: Access DB objects in same schema without qualifying? -