Given table

planGraf

with fields

 regNum inn xml vNum

for this query SELECT * FROM dbo.planGraf WHERE regNum='01213213545447' OR inn='546488421' prints 2 lines with different vNum. How to write a cast to display a string on the maximum vNum?

    1 answer 1

     SELECT TOP 1 T.[regNum] ,T.[inn] ,T.[xml] ,T.[vNum] FROM dbo.planGraf AS T WHERE regNum='01213213545447' OR inn='546488421' ORDER BY vNum DESC