Query for find distinct record from table

Hi ..

U can use query like below one.

select distinct name,product from sales 

hey in your query remove o.id because
for Priyam Shah you have 2 order id. hence it is giving to records.
try below query :-

select distinct U.FirstName+' '+U.LastName as 'Full Name',U.City,U.Email,U.Mobile
from [User] U
inner join [Order] O on U.ID=O.UserID
where U.City like '%puna%'
order by O.ID desc

Your query returns two rows because the same person have different order ID

Your query returns two rows other data same except Different OrderID because the same person have different order ID
So if u get unike record then remove OrderID...........


SELECT
DISTINCT U.Email,
U.FirstName+' '+U.LastName as 'Full Name',
U.City,
U.Mobile
FROM
[User] U
INNER JOIN
[Order] O ON U.ID=O.UserID
WHERE
U.City like '%puna%'

Try this..





create table tbl_User(
ID int primary key,
FirstName varchar(500),
LastName varchar(500),
City varchar(500),
Email varchar(500),
Mobile int)

create table tbl_Order(
UserId int,
OrderId int primary key)

insert into tbl_User values (1,'priyam','shah','Rajkot','f@gmail.com',12345678)
insert into tbl_order values (1,5001)
insert into tbl_order values (1,5002)


With Cte_test as
(select U.FirstName+' '+U.LastName as 'Full Name',U.City,U.Email,U.Mobile,O.orderID as 'Order ID',
ROW_NUMBER() over (Partition by Id order by orderId desc) as Rownumber
from [tbl_User] U
inner join [tbl_Order] O on U.ID=O.UserID)
select [Full name],City,Email,Mobile,[Order Id] from Cte_test where Rownumber=1