Question: I have seen one place that they had put Bootstrap 3 into Tiny MCE 4. That looked very nice and practical, and I now want to do that too.

I have searched through Google, but not been able to find how to do that. 

Do you know? Please share :-)

Answer: 
If the Number is not always increasing and thus could have different MAx within each Record group, you have to do it in two steps i.e. first get MAX(Record) and then get MAX(Number).

```
SELECT T.[Order], Max(Number) AS MaxNumber, MaxRecord
FROM
(
    SELECT [Order], Max(Record) AS MaxRecord
    FROM Table1
    GROUP By [ORDER]
) T
INNER JOIN Table1 T1 ON T.[Order] = T1.[Order] AND T.MaxRecord = T1.Record
GROUP By [ORDER]

```
Assuming your table is called `Table1`, the following should give you what you are looking for:

```
SELECT  MAX(number),
        A.record,
        [order]
  FROM  Table1 A
    INNER JOIN (  SELECT  MAX(record) record
                    FROM  Table1) B ON A.record = b.record
  GROUP BY A.record, [order]

```

This will effectively find the maximum `record` and then return the maximum `number` for this `record`.