Software Applications Programming Errors and solutions.

Posts

Showing posts with the label Group by with like in sql select query

Group by with like in sql select query

If you have a table which has values like a,b,c and you want to get count like start from a,b or c columns value then you can use query following way. Select Left( name, 1) AS NameCaps, Count(name) as Name From Table_my GROUP BY Left( name, 1)