Hi! I have table with information. The price and date have duplicates. How I can get information from table unique.
Cod_acct_no
|
Name
|
Date
|
Wares
|
Price
|
2023070601
|
Shodmon
|
20.03.2023
|
Car
|
6000
|
2023070601
|
Shodmon
|
20.03.2023
|
Car
|
6500
|
2023070602
|
Orifkhon
|
20.05.2023
|
house
|
16000
|
2023070602
|
Orifkhon
|
20.05.2023
|
house
|
16300
|
2023070603
|
Rustam
|
20.04.2023
|
house
|
20000
|
2023070604
|
Firuz
|
20.05.2022
|
flat
|
21000
|
2023070605
|
Sadriddin
|
20.09.2022
|
bus
|
41000
|
2023070605
|
Sadriddin
|
21.09.2022
|
bus
|
41000
|
My requirements in bellow:
Cod_acct_no
|
Name
|
Date
|
Wares
|
Price
|
2023070601
|
Shodmon
|
20.03.2023
|
Car
|
6500
|
2023070602
|
Orifkhon
|
20.05.2023
|
house
|
16300
|
2023070603
|
Rustam
|
20.04.2023
|
house
|
20000
|
2023070604
|
Firuz
|
20.05.2022
|
flat
|
21000
|
2023070605
|
Sadriddin
|
21.09.2022
|
bus
|
41000
|