只查询，表中的最后10条记录，这个查询语句咋写啊？(100分)

刚才没说清楚，我需要的的是带条件的语句。比如表中有100条记录，有30条符合要求，我只要最后10条符合要求的记录。要求用一个查询语句实现。<br>谢谢！

Oracle好办<br>SqlServer要有主键<br>select top 10 * from table order by 主键 desc

不行啊，报错，top是不是不能用在mysql数据库呀。

前两天刚卸载了MySql,没有试,平时也用的不多,你试试看<br>select * from table order by 主键 desc limit 10

select top 10 * from table order by 主键 desc

刚才没说清楚，我需要的的是带条件的语句。比如表中有100条记录，有30条符合要求，我只要最后10条符合要求的记录。要求用一个查询语句实现。

select * from table where 你的条件 order by 主键 desc limit 10

SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]<br>&nbsp; &nbsp; &nbsp; &nbsp;[DISTINCT | DISTINCTROW | ALL]<br>&nbsp; &nbsp; select_expression,...<br>&nbsp; &nbsp; [INTO {OUTFILE | DUMPFILE} 'file_name' export_options]<br>&nbsp; &nbsp; [FROM table_references<br>&nbsp; &nbsp; &nbsp; &nbsp; [WHERE where_definition]<br>&nbsp; &nbsp; &nbsp; &nbsp; [GROUP BY col_name,...]<br>&nbsp; &nbsp; &nbsp; &nbsp; [HAVING where_definition]<br>&nbsp; &nbsp; &nbsp; &nbsp; [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]<br>&nbsp; &nbsp; &nbsp; &nbsp; [LIMIT [offset,] rows]<br>&nbsp; &nbsp; &nbsp; &nbsp; [PROCEDURE procedure_name] ]

多谢浪人情哥，已解决。

多人接受答案了。