求一个mysql的sql语句。 表productid,name,price1 ,aa,422,bb,223,bb,33用一个sql句子取按价格(price)排序后的第二条记录。谢谢大家 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 表productid,name,price1 ,aa,422,bb,223,bb,33select * from product order by price limit 1,2;不在公司,没调试过,你看看对不对 mysql> create table product( id int ,name varchar(20),price int);Query OK, 0 rows affected (0.01 sec)mysql> insert into product select 1,'aa',42 union select 2,'bb',22 union select 3,'bb',33 ;Query OK, 3 rows affected (0.00 sec)Records: 3 Duplicates: 0 Warnings: 0mysql> select * from product;+------+------+-------+| id | name | price |+------+------+-------+| 1 | aa | 42 || 2 | bb | 22 || 3 | bb | 33 |+------+------+-------+3 rows in set (0.00 sec)mysql> select * from product order by price limit 1,1;+------+------+-------+| id | name | price |+------+------+-------+| 3 | bb | 33 |+------+------+-------+1 row in set (0.00 sec) 用mysql migration tools从SQLSERVER到MYSQL的中文乱码问题如何解决啊? left join 缺省值 mysql数据库导出问题 请教:MYSQL插入数据报错 mysql如何使用engine MYSQL安装错误 很郁闷 mysql 能否指定表的路径? 怎样防止sql注入?? 高手快来帮帮我,如果将原来字段并上一个值?! 在线等 mysql存储过程 error ado+mysql, utf8编码, 奇数个汉字时最后一个汉字被截掉 我是在winXP下安装的mysql5版,运行->mysql command line Client后,确不知如何往下进行?
id,name,price
1 ,aa,42
2,bb,22
3,bb,33select * from product order by price limit 1,2;不在公司,没调试过,你看看对不对
Query OK, 0 rows affected (0.01 sec)mysql> insert into product select 1,'aa',42 union select 2,'bb',22 union select 3,'bb',33 ;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0mysql> select * from product;
+------+------+-------+
| id | name | price |
+------+------+-------+
| 1 | aa | 42 |
| 2 | bb | 22 |
| 3 | bb | 33 |
+------+------+-------+
3 rows in set (0.00 sec)mysql> select * from product order by price limit 1,1;
+------+------+-------+
| id | name | price |
+------+------+-------+
| 3 | bb | 33 |
+------+------+-------+
1 row in set (0.00 sec)