Filtering a result set to show or hide specific result in SQL Server -
using "select [users],[stars] [table]", here example result set returned: <table border="1"> <th>users</th> <th>stars</th> <tr> <td>admin</td><td>3</td> </tr> <tr> <td>worker</td><td>4</td> </tr> <tr> <td>student</td><td>2</td> </tr> </table> how show admin if has more 3 stars , not part of result set if 3 stars or less? my best guess case when statement go in select or clause? i'm still quite new development , appreciated. this should cover using clause select [users], [stars] [table] [users] != 'admin' or [stars] > 3