How to find the small and big id in mysql

Question

Here the Situation . I am having 2 million records in table .

Just consider the contacts tables has id filed. and id has different number . But now i want to find the smallest and largest id from contacts table .

Answer 1

SELECT min(id_field),max(id_field) FROM table;

This will work for both tables.

Answer 2

you're looking for min and max.

SELECT min(id),max(id) FROM table;