Hello! I have a table with n-rows. I make a select request

Question

Hello! I have a table with n-rows. I make a select request

select * from topics order by views desc limit 3 offset 39;
in result i have rows with ids - 151, 49, 21;
Next, make another request -
select * from topics order by views desc limit 3 offset 42;
in result i have rows with ids 49, 176, 117
Values of views column are equals
How i can except duplicates ids(49)?
MySQL (ver. 8.0.32)

#english #programming #sql

0

23.07.2024

1 ответов

20 просмотров

Dr.Possible⚡☀️ · Accepted Answer

Dr.Possible⚡☀️

use distinct

0

4 месяца назад

169 похожих чатов

Hello! I have a table with n-rows. I make a select request

1 ответов

Похожие вопросы