MySQL - Query to order by second column if first column value is same

Question

SELECT * 
FROM `user_job_application` 
ORDER BY `user_job_application`.`user_id` DESC

It gives the table result like image preview. but when user_idis same then, I want to fetch result order by user_job_application_date desc

Answer 1

We can ORDER results using multiple columns.

Try this:

SELECT * 
FROM `user_job_application` 
ORDER BY `user_job_application`.`user_id` DESC, user_job_application_date desc