Use the select and order by statement choose max_area maximum in the first two residential complex i-CodePudding

Home > database > Use the select and order by statement choose max_area maximum in the first two residential complex i

Use the select and order by statement choose max_area maximum in the first two residential complex i

Time：09-21

Table homelink submit is decision function of SQL statement submitted with the

CodePudding user response:

Select a. *
The from homelink a
Where a.t ype='homes'
The order by max_area desc
Limit 2

CodePudding user response:

Select a. *
The from homelink a
Where a.t ype='homes'
The order by max_area desc
Limit 2

CodePudding user response:

Select a. *
The from homelink a
The order by max_area desc
Limit 2