# How to take the UNIQUE or first Row

**URL:** <https://www.epiusers.help/t/how-to-take-the-unique-or-first-row/63999>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [January 28, 2020, 3:35pm UTC](https://www.epiusers.help/t/how-to-take-the-unique-or-first-row/63999 "2020-01-28T15:35:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![windowsmanager](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/7c8e57/32.png) [@windowsmanager](https://www.epiusers.help/u/windowsmanager)\
**Post date:** [January 28, 2020, 3:35pm UTC](https://www.epiusers.help/t/how-to-take-the-unique-or-first-row/63999/1 "2020-01-28T15:35:23Z")

</div>

Would someone please show me how can I take the first row out of this query or get the UNIQUE values in this query.

var kquery = (from OrderH in Db.OrderHed  
join OrderD in Db.OrderDtl on OrderH.OrderNum equals OrderD.OrderNum  
join OrderR in Db.OrderRel on OrderH.OrderNum equals OrderR.OrderNum  
join ShipT in Db.ShipTo on OrderH.ShipToNum equals ShipT.ShipToNum  
where (  
(string.Compare(OrderD.Company, callContextClient.CurrentCompany, true ) == 0) &&  
(string.Compare (OrderH.Company, callContextClient.CurrentCompany, true) == 0) &&  
( (int)OrderH.OrderNum == (int)OrderHeaderXRow2.OrderNum) &&  
( (int)OrderD.CustNum == (int)ShipT.CustNum )  
)  
select new {  
HCompany = OrderH.Company  
,HOrderNum = OrderH.OrderNum  
,HCustNum= OrderH.CustNum  
,HOTSState = OrderH.OTSState  
,HOTSCountryNum = OrderH.OTSCountryNum  
,HUseOTS = OrderH.UseOTS  
,HShipToNum = OrderH.ShipToNum  
,HCheckBox07 = OrderH.CheckBox07  
,HCheckBox08 = OrderH.CheckBox08  
,HCheckBox19 = OrderH.CheckBox19  
,HCheckBox20 = OrderH.CheckBox20  
,RCheckBox17 = OrderR.CheckBox17  
,SState = ShipT.State  
,SCountry = ShipT.Country

}).ToList();

---

<div class="post-metadata">

**Author:** ![tsmith](https://www.epiusers.help/user_avatar/www.epiusers.help/tsmith/32/64774_2.png) [@tsmith](https://www.epiusers.help/u/tsmith)\
**Post date:** [January 28, 2020, 3:47pm UTC](https://www.epiusers.help/t/how-to-take-the-unique-or-first-row/63999/2 "2020-01-28T15:47:21Z")

</div>

To get unique values, you can just add a Distinct() call before your ToList():

```cs
(LINQ query).Distinct().ToList();

```

---

<div class="post-metadata">

**Author:** ![windowsmanager](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/7c8e57/32.png) [@windowsmanager](https://www.epiusers.help/u/windowsmanager)\
**Post date:** [January 28, 2020, 4:11pm UTC](https://www.epiusers.help/t/how-to-take-the-unique-or-first-row/63999/3 "2020-01-28T16:11:42Z")

</div>

THANK YOU VERY much …

---

<div class="post-metadata">

**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\
**Post date:** [January 28, 2020, 5:48pm UTC](https://www.epiusers.help/t/how-to-take-the-unique-or-first-row/63999/4 "2020-01-28T17:48:13Z")

</div>

Remember to mark it as solution if it is the solution @windowsmanager