database

[S madasamy]

how to select maximum number from table using groupby keyword with two column name

[Wendelius]

A little example data would help the answering, but basically you group by like:

SELECT MAX(NumberField),
Field1,
Field2
FROM YourTable
GROUP BY Field1,
Field2

For info and examples, see: GROUP BY (Transact-SQL)[^]

The need to optimize rises from a bad design.My articles[^]

[Abhinav S]

You have already posted this in the Q&A section. Try avoiding cross-posts.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.