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]

```
Order really isn't a good column name as it's a reserved word.

```
SELECT max(number), max(record), order
FROM Table1
group by order

```

This might not be right, I'll need some clarification. Your question is a bit confusing...this will return the max number and record for each order number. Were you looking for the max record in reference to the max number? IE:

555 777 1

666 555 1

In this case, would you expect to see 666 777 1, or 555 777 1?