本文介绍了一个SQL查询案例，展示了如何通过连接多个表并排序来获取特定数据。具体包括使用INNER JOIN连接room、roomType及subHotel表，并按价格排序后进行分页展示。
select r.id as rid,rt.id as rtid,rt.roomname as rtroomname,r.roomPrice as rroomPrice,
r.maxNum as rmaxNum,r.roomDescript as rroomDescript,sh.id as shid,sh.subHotelName as shsubHotelName,
sh.subHotelAddress as shsubHotelAddress ,sh.isLeader as shisLeader
from room as r INNER JOIN roomType as rt on r.roomTypeId=rt.id
inner join subHotel as sh on r.subHotelId=sh.id order by r.roomPrice asc limit 5,5
room 表
roomType 表
subHotel 表
对应关系是
room.roomTypeid=roomType.id
room.subhotelid=subhotel.id
//排序这后，还可以分页，好像以前不行吧，这是我现在的疑问，先记下吧
扫一扫
3万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
