Fetch unique userID from database with a given date

Question

|--------------------------------------
|  luid |  alti   | lati  |   sdate   | 
|--------------------------------------
|  14  |  11.222  | 11.22 |18-10-2016 |
|  14  |  22.333  | 11.22 |18-10-2016 |
|  12  |  32.111  | 11.22 |18-10-2016 |
|  12  |  11.234  | 11.22 |18-10-2016 |
|  13  |  24.555  | 11.22 |18-10-2016 |
|  16  |  16.000  | 11.22 |19-10-2016 |
---------------------------------------

I want to fetch the unique luid from the table of 18-20-2016 and the total column also.

How can I do it?

Welcome to StackOverflow. Please note, that this is not a free code-writing service, but we are eager to help fellow programmers (and aspirants) writing their own code. Please read the help topics on [How to ask a good question](http://stackoverflow.com/help/how-to-ask). Afterwards, please update your question with the code you have written thus far in order to complete the task(s) you wish to achieve. — Quintin Balsdon, Dec 19 '16 at 08:19
Try `DISTINCT`. http://stackoverflow.com/questions/8571902/mysql-select-only-unique-values-from-a-column this can be helped. — Chonchol Mahmud, Dec 19 '16 at 08:23

b03Developer · Answer 1 · 2016-12-19T08:45:25.953

0

Try,

SELECT DISTINCT(Column_Name) AS Column_Name FROM Table_Name ORDER BY Column_Name DESC;

edited Dec 19 '16 at 08:45

answered Dec 19 '16 at 08:24

b03Developer

93
8

score 0 · Answer 2 · answered Dec 19 '16 at 08:31

0

TRY This SELECT luid from table WHERE sdate="required date" Group By luid

answered Dec 19 '16 at 08:31

rohitr

371
2
11

Fetch unique userID from database with a given date

2 Answers2