حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Get unique record from duplicate rows in SQL Server

PRA

PRA

SOLVED CLOSED ACTIVE ANSWERED
User: PRA
Posted: on Jul 06, 2023 05:07 AM
Forum: SQL Server
Answer: 1
Views: 585

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

Download FREE API for Word, Excel and PDF in ASP.Net

dharmendr

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Jul 06, 2023 05:08 AM
Report

Refer

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Banner

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.