Question: How can I select the row with the highest ID in MySQL? This is my current code:

```
SELECT * FROM permlog WHERE max(id)

```

Errors come up, can someone help me?

Answer: 
Suppose you have mulitple record for same date or leave\_type but different id and you want the maximum no of id for same date or leave\_type as i also sucked with this issue, 
so Yes you can do it with the following query:

```
select * from tabel_name where employee_no='123' and id=(
   select max(id) from table_name where employee_no='123' and leave_type='5'
)

```
```
SELECT * FROM `permlog` as one
RIGHT JOIN (SELECT MAX(id) as max_id FROM `permlog`) as two 
ON one.id = two.max_id

```