How to delete duplicate from this result

```
select *,
       row_number() over (order by (select null)) as seqnum
from [elo].[dbo].[objkeys] 
where parentid in (select parentid
                   from [elo].[dbo].[objekte] 
                   inner join [elo].[dbo].[objkeys] on objid = parentid 
                   where objmask like 26 and okeydata like 'yes'
                   )

```

output is

```
parentid   okeyname  okeydata
  1          name   a
  1      number     1
  1        yes_no   yes 
  2          name   a
  2      number     1
  2        yes_no   yes
  3          name   a
  3      number     1
  3        yes_no   no
  4          name   a
  4      number     2
  4          yes_no no
  5          name   b
  5      number     3
  5          yes_no yes
  6          name   b
  6      number     3
  6          yes_no yes
  7          name   b
  7      number     3
  7          yes_no no
  8          name   b
  8      number     3
  8          yes_no no

```

need to be like this

```
parentid   okeyname  okeydata
  1          name   a
  1      number     1
  1          yes_no yes 

  3          name   a
  3      number     1
  3          yes_no no

  5          name   b
  5      number     3
  5          yes_no yes

  7          name   b
  7      number     3
  7          yes_no no

```
['https://Stackoverflow.com/questions/56323181', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/10306114/']
Can you please try **ml-auto** instead of **mr-auto**?

So the ul tag will be like this

```
<ul class="navbar-nav ml-auto">

```
Please check the following Stack Overflow post

[What happened to the .pull-left and .pull-right classes in Bootstrap 4?](https://stackoverflow.com/questions/39655110/what-happened-to-the-pull-left-and-pull-right-classes-in-bootstrap-4/42887127)

Hope this helps you out.