newbie reply.....

My understanding is that GROUP BY clauses work in conjunction with aggregate queries, such as SUM, AVG, etc.

For example, if you have a list of cars and want to...

Newbie to newbie -

To view list of tables I run

sp_tables

Let's say there's a table called "ITEMS", to see its columns I run

sp_columns ITEMS

Gets the job done but if there's...