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]

```
Hi this is the another way to do to get the result 

```
select MAX(t.number),MAX(t.record),t.ORDERNo from @table t
INNER JOIN @table tt
ON tt.ORDERNo = t.ORDERNo
AND tt.Number = t.Number
AND t.Record = tt.Record
GROUP BY t.ORDERNo

```