Hello,
I have a small SQL question.
Running an example queries in our Samples Namespace:
1. select top 5 Description,Category from Cinema.Film order by Category - runs fine no issues and returns 2 columns as expected
2. select top 5 * from Cinema.Film order by Category - runs fine no issues and returns 8 columns as expected
3. select top 5 Description,Category,* from Cinema.Film order by ID - runs fine no issues, and returns 10 columns, with my first 2 repeated
4. When I try to combine the first 2 queries: