谨慎小刺猬

文章
3
资源
0
加入时间
4年1月25天

sql查询取第一条数据

数据全查询SELECT * FROM edu_course ec ORDER BY priceMySQLSELECT * FROM edu_course ec ORDER BY price DESC LIMIT 1sqlserverSELECT TOP 1* FROM edu_course ec ORDER BY price DESCOracleSELECT * FROM(SELECT * FROM EDU_COURSE ORDER BY price DESC) WHERE ROWN