Return specific row and desc order in sql in php

Return specific row and desc order in sql in php

i want my query to return a specific row of the table where a column contains specific value first and with year desc.

i want my query to return a specific row of the table where a column contains specific value first and with year desc.

if i have table something like this

Table employee

 id  - Name    -    Year - Status 
  1  - Ashish  -    2016 - Old
  2  - Srisan  -    2017 - New
  3  - Mohit   -    2018 - New
  4  - Ram     -    2015 - Old
  5  - Boby    -    2016 - New

then result should be

 id -  Name   -  Year - Status 
  3 -  Mohit  -  2018 - New
  2 -  Srisan -  2017 - New
  5 -  Boby   -  2016 - New
  1 -  Ashish -  2016 - Old
  4 -  Ram    -  2015 - Old

Where Status is new and sort via desc of Year

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Building PHP apps using SQL Server on Windows

3 step: Building PHP apps using SQL Server on Windows

PhP MySQL Projects

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts and trainers.

What are the differences between Standard SQL and Transact-SQL?

In this article, we'll explain syntax differences between standard SQL and the Transact-SQL language dedicated to interacting with the SQL