sql查询从列中查找最后十个DISTINCT手机号码 [英] sql query to find last ten DISTINCT mobile numbers from column

问题描述

有人可以帮我找到:
sql查询可从列中查找最后十个DISTINCT手机号码.
我的架构有3列ID，User_No，当前日期.
我想要最后10个不同的手机号码，并将它们显示在数据列表中.

can someone help me to find :
sql query to find last ten DISTINCT mobile numbers from column.
my schema has 3 columns id,User_No,Current Date.
i want last 10 distinct mobile numbers and show them in data list

推荐答案

这将仅返回不同的电话号码:

This will return only distinct phone numbers:

SELECT DISTINCT TOP 10 User_No FROM  YourTable
ORDER BY id DESC

没有您的模式会非常困难，但是

Very hard without your schema, but

select top 10 * from (select distinct * from table order by datecolumn) as t

尝试:

SELECT TOP 10 * FROM MyTable ORDER BY MyPrimaryKeyID DESC

如果您有插入的datetime列，请使用该列进行排序.逻辑是根据序列排序，然后获得前10行.

If you have a datetime column of insertion then use that for sorting. Logic is to sort based on a sequence and then get top 10 rows.

这篇关于sql查询从列中查找最后十个DISTINCT手机号码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！