如何选择最后插入的两行 [英] How to select last two inserted rows

问题描述

我想从表中选择最后插入的两行.我怎样才能做到这一点?

其次，我有一个员工表，我想选择那5个薪水最高的员工.

请使用

Hi,

I want to select last inserted two rows from my table. How can I do that?

Secondly I have an Employee Table I want to select those 5 employee whose salary is maximum.

Please guide

推荐答案

SELECT TOP(2) * FROM [tablename] ORDER BY Id DESC

第二个是

second is

SELECT TOP(5) * FROM [table] ORDER BY salary DESC

这篇关于如何选择最后插入的两行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！