How get last row from each group

Question

I have three tables (Subscripers, Subscriptions and Payments). Where the every subscriper can do one or more of subscriptions and the subscriper Pay more than one in the payments table of every subscription.
Now .How can I show all subscriptions and get only last payment of each subscription without replication the subscriptions data in the results
how write sql code:
SELECT dbo.Subscriptions.Id, dbo.Subscripers.subscriperName, dbo.Payments.isPaid
FROM dbo.Subscriptions  ( ... )
Relationship diagram as:
The Result show replications in subscriptions data as the follow Image :
Script of Schema With Data as the follow:
Create   Database  ThreeTables   go   USE ThreeTables   GO   /****** Object:  Table  [dbo].[Payments] Script  Date : 8/3/2019 7:29:42 PM ******/   SET  ANSI_NULLS  ON    GO   SET  QUOTED_IDENTIFIER  ON    GO   CREATE   TABLE  [dbo].[Payments](   [Id] [nvarchar](128)  NOT   NULL ,   [isPaid] [ bit ]  NOT   NULL ,   [subscriptionId] [ decimal ](18, 2)  NOT   NULL    CONSTRAINT  [PK_dbo.Payments]  PRIMARY   KEY  CLUSTERED   (   [Id]  ASC    ) WITH  (PAD_INDEX =  OFF , STATISTICS_NORECOMPUTE =  OFF , IGNORE_DUP_KEY =  OFF , ALLOW_ROW_LOCKS =  ON , ALLOW_PAGE_LOCKS =  ON )  ON  [ PRIMARY ]   )  ON  [ PRIMARY ]   GO   /****** Object:  Table  [dbo].[Subscripers] Script  Date : 8/3/2019 7:29:43 PM ******/   SET  ANSI_NULLS  ON    GO   SET  QUOTED_IDENTIFIER  ON    GO   CREATE   TABLE  [dbo].[Subscripers](   [Id] [nvarchar](128)  NOT   NULL ,   [subscriperName] [nvarchar]( max )  NULL ,   CONSTRAINT  [PK_dbo.Subscripers]  PRIMARY   KEY  CLUSTERED   (   [Id]  ASC    ) WITH  (PAD_INDEX =  OFF , STATISTICS_NORECOMPUTE =  OFF , IGNORE_DUP_KEY =  OFF , ALLOW_ROW_LOCKS =  ON , ALLOW_PAGE_LOCKS =  ON )  ON  [ PRIMARY ]   )  ON  [ PRIMARY ] TEXTIMAGE_ON [ PRIMARY ]   GO   /****** Object:  Table  [dbo].[Subscriptions] Script  Date : 8/3/2019 7:29:43 PM ******/   SET  ANSI_NULLS  ON    GO   SET  QUOTED_IDENTIFIER  ON    GO   CREATE   TABLE  [dbo].[Subscriptions](   [Id] [ decimal ](18, 2)  NOT   NULL ,   [SubscriptionState] [nvarchar]( max )  NULL ,   [Subscriper_Id] [nvarchar](128)  NULL ,   CONSTRAINT  [PK_dbo.Subscriptions]  PRIMARY   KEY  CLUSTERED   (   [Id]  ASC    ) WITH  (PAD_INDEX =  OFF , STATISTICS_NORECOMPUTE =  OFF , IGNORE_DUP_KEY =  OFF , ALLOW_ROW_LOCKS =  ON , ALLOW_PAGE_LOCKS =  ON )  ON  [ PRIMARY ]   )  ON  [ PRIMARY ] TEXTIMAGE_ON [ PRIMARY ]   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N '2c9a266d-a455-4b7f-a1a3-8b45c222a449' , 0,  CAST (2.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N '351fbaf4-11cb-4584-bafe-3266dc629968' , 0,  CAST (11.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N '60eec856-3001-4522-a522-96c459a03c3b' , 0,  CAST (5.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N '7c54991a-c3d2-4649-a999-394c4476fa13' , 0,  CAST (1.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N '825a31ca-9494-484a-a948-4b60404752b3' , 0,  CAST (8.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N '841ebc8d-46a1-409b-8b84-eb058c3901ac' , 0,  CAST (7.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id],[isPaid], [subscriptionId])  VALUES  (N '92b04b7e-22d9-4134-aab4-ca2a30e52998' , 0,  CAST (9.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N 'a5c96a97-1bd4-4992-b5ee-9a90e1c559b3' , 0,  CAST (1.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N 'bae98c93-b048-410a-bdb9-63391e34fc4d' , 0,  CAST (3.00  AS   Decimal (18, 2)))   GO   INSERT  [dbo].[Payments] ([Id], [isPaid], [subscriptionId])  VALUES  (N 'e5affae4-c687-404b-8826-9b5f2f83a500' , 0,  CAST (10.00  AS   Decimal (18, 2)))   GO…

Abdulmajeed Alshari · Answer

It is not duplicate in subscriptions table. These duplicated because I using select from three tables as the follow : SELECT  dbo.Subscriptions.Id, dbo.Subscripers.subscriperName, dbo.Payments.isPaid   FROM  dbo.Payments  RIGHT   OUTER   JOIN    dbo.Subscriptions  ON  dbo.Payments.subscriptionId = dbo.Subscriptions.Id  LEFT   OUTER   JOIN    dbo.Subscripers  ON  dbo.Subscriptions.Subscriper_Id = dbo.Subscripers.Id   and the reason for repeating the id because the subscription number 1 was appear twice to a Payments table as the follow :

Amit Gupta · Answer

You can get the desired output using the max keyword

Amit Gupta · Answer

How the database accepted the same id which is a primary key marked?