Excuse me everybody I have a set of data are Numbers with decimal point behind, I need to get the data, if the decimal point in front of the Numbers after the decimal point as the big one, could you tell me how to write the query statements, thank you ~ ~ ~
Such as the data query get blue after the

CodePudding user response:

The SELECT MAX (A.T JBH) FROM TABLE A GROUP BY ROUND (A.T JBH, 0)

CodePudding user response:

SELECT *
The FROM (SELECT *, ROW_NUMBER () OVER (PARTITION BY FLOOR (TJBH) ORDER BY TJBH DESC) AS an RN FROM the TABLE) AS A
WHERE an RN=1