Sql Help Please

[RockyBhai]

I have Sno, ID, DateTime, X, Y, Z Columns in my table. Sno is unique and  ID column will have duplicates.

I want to query all Distinct ID’s with latest DateTime.

 

Appreciate your help!

 

[awaraa]

distinct ids and max(datetime) cheyi 

[LungiLingaraju]

Group by ID and max(date) .... 

 

mention the  database you are using .. 

[Spartan]

6 minutes ago, RockyBhai said:

I have Sno, ID, DateTime, X, Y, Z Columns in my table. Sno is unique and  ID column will have duplicates.

I want to query all Distinct ID’s with latest DateTime.

 

Appreciate your help!

 

https://www.w3schools.com/sql/sql_distinct.asp

SELECT DISTINCT column1, column2, ...
FROM table_name;

SELECT DISTINCT column1, column2, ...
FROM table_name; 

 

[RockyBhai]

Thanks bro below worked

select distinct ID, max(DateTime) from tablename group by id order by max(DateTime) desc, ID

[RockyBhai]

20 minutes ago, LungiLingaraju said:

Group by ID and max(date) .... 

 

mention the  database you are using .. 

Sql. Thanks for your time bro

[RockyBhai]

21 minutes ago, awaraa said:

distinct ids and max(datetime) cheyi 

Thanks bro

[Picheshwar]

22 minutes ago, RockyBhai said:

Thanks bro below worked

select distinct ID, max(DateTime) from tablename group by id order by max(DateTime) desc, ID

group by vadutunnav.. dISTINCT endhuku bokka