sql query to find last ten DISTINCT mobile numbers from column

Question

0.00/5 (No votes)

See more:

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

Posted 5-Jun-12 1:15am

gaurav786mishra

Updated 5-Jun-12 1:20am

v2

Add a Solution

Comments

PunithaSabareeswari 5-Jun-12 7:18am

"select top(10) mobno from Table_name"

It may be used for u...... Use It

taha bahraminezhad Jooneghani 5-Jun-12 8:30am

for which Scenario?

5 solutions

Solution 3

This will return only distinct phone numbers:

SQL

SELECT DISTINCT TOP 10 User_No FROM  YourTable
ORDER BY id DESC

Posted 5-Jun-12 1:30am

Oshtri Deka

Solution 1

Very hard without your schema, but

SQL

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

Posted 5-Jun-12 1:18am

Mehdi Gholam

Solution 2

Try:

SQL

SELECT TOP 10 * FROM MyTable ORDER BY MyPrimaryKeyID DESC

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.

Posted 5-Jun-12 1:22am

Sandeep Mewara

Comments

gaurav786mishra 5-Jun-12 7:28am

i want last ten distinct User_No

Sandeep Mewara 5-Jun-12 9:35am

Did you follow the answer?

SELECT TOP 10 User_No FROM MyTable ORDER BY User_No DESC

Solution 4

Try this:

SQL

select DISTINCT mobNo
  from (select * from &lt;table name&gt; order by id, date desc) p
 where rownum &lt;= 10  ORDER BY mobNo;

have look on:
Last n records[^]

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/ca7cfd7d-532e-455c-956e-54b95eeb26a8[^]

http://www.sitepoint.com/forums/showthread.php?623264-SQL-Query-to-get-latest-but-unique-records[^]

Posted 5-Jun-12 1:34am

codeBegin

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

gaurav786mishra · Accepted Answer · 2012-06-05T01:38:00

Solution 5

SQL

select top 20 user_no from tbl_webservicedata group by user_no order by max(id)desc

Posted 5-Jun-12 1:38am

gaurav786mishra

Updated 5-Jun-12 2:27am

v2