MySQL- How to select distinct data against a same record

Question

Referring to the question asked. I have a table which includes multiple records for the same entry like below image

All I want is to select the single record against each entry. I have also set the DB and Query in DB Fiddle

Any help would be highly appreciated.

i can see there is little bit time fraction , do you need a single entry for each date? — Zaynul Abadin Tuhin, Jul 24 '18 at 05:58
You'll have to add a additional column for referring to single row with much less complexity in query and to be reliable say like a ID column — Naresh Kumar, Jul 24 '18 at 06:17
@NareshKumar I can't perform any operation(s) other than `select` on the table. — Moeez, Jul 24 '18 at 06:20
Ok then use nested query to select rows and then again select distinct row from the obtained selection — Naresh Kumar, Jul 24 '18 at 06:21

score -1 · Accepted Answer · edited Jul 24 '18 at 09:36

-1

From discussion got you need convert datetime to date and group by clause column to date

for your table

SELECT  p.`zdjh` AS MSN, max(p.`sjsj`) AS Date_Time,max( p.`xhqd`) AS Ping 
FROM `tj_xhqd` p
WHERE p.`sjsj` <='2018-07-24 10:15:00' AND p.`sjsj` >='2018-07-23 10:15:00'
group by zdjh
ORDER BY MSN, Date_Time, Ping DESC

edited Jul 24 '18 at 09:36

Moeez

494
9
55
147

answered Jul 24 '18 at 05:56

Zaynul Abadin Tuhin

31,407
5
33
63

All times are distinct – Strawberry Jul 24 '18 at 06:01
down voter can you please say the reason of downvote? – Zaynul Abadin Tuhin Jul 24 '18 at 06:01
@Strawberry and thats why i asked him what he needs? – Zaynul Abadin Tuhin Jul 24 '18 at 06:02
@ZaynulAbadinTuhin Kindly see my fork [query](https://www.db-fiddle.com/f/2BftScoRwB739YiiMoL9jY/0) – Moeez Jul 24 '18 at 06:10
@MrFaisal i changed my query according to your table structure – Zaynul Abadin Tuhin Jul 24 '18 at 06:14
@ZaynulAbadinTuhin did you tried to run it in the [DB Fiddle](https://www.db-fiddle.com/f/2BftScoRwB739YiiMoL9jY/0)? Because I can see it makes no difference as I am still not able to see single record – Moeez Jul 24 '18 at 06:15
@MrFaisal https://www.db-fiddle.com/f/2BftScoRwB739YiiMoL9jY/0 check this – Zaynul Abadin Tuhin Jul 24 '18 at 06:16
@ZaynulAbadinTuhin I have seen it. But still it's no giving me single record – Moeez Jul 24 '18 at 06:18
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/176610/discussion-between-zaynul-abadin-tuhin-and-mr-faisal). – Zaynul Abadin Tuhin Jul 24 '18 at 06:19

MySQL- How to select distinct data against a same record

1 Answers1