LIMIT query

[zeero]

Hi all,

I have a query that returns all the room numbers in a hotel. What would be the proper syntax for a query to return one instance of each room. e.g. i want 1 2 3 4, etc. instead of 1 1 1 1 1 2 2 2 2 2 3 3 3 3 3, etc.)

Thanks

 

[ericbrunson]

select distinct or use a group by clause.