查询使用订单子句获取数据

Question

I have Below Database Table named cart_data

I want to Show the Record on the Basis of Requested Cart No

Kindly tell me the query.

Answer 1

"SELECT * FROM cart_data ORDER BY requested_cart_no" 

or optionally assign the order ASC | DESC

"SELECT * FROM cart_data ORDER BY requested_cart_no DESC" 

or, for a single record use 'WHERE' clause , the operator ( = | > | < | >= ...) and the value you need. es:

"SELECT * FROM cart_data WHERE requested_cart_no > 5"