troubleshooting Question

SQL Query help

Avatar of KAbbott
KAbbottFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerSQL
4 Comments1 Solution208 ViewsLast Modified:
Hi,

I have a data structure like this:

tblTest
nId,     txtSubTitle,     numSort
0         test1               0
1         test4               4
2         test2               2
3         test3               3
4         test4               2
5         test2               1
etc, etc...

I want to return each unique txtSubTitle with the lowest numSort value.
I thought this would work:

I tried "SELECT DISTINCT txtSubTitle, MIN(numSort) AS Expr1 FROM tblTest ORDER BY Expr1"

But I get an error message about GROUP BY clause, can anyone help?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros