How to write such a query in SQL?

F

Fertehr2021-07-25 19:57:53

SQL

Fertehr, 2021-07-25 19:57:53

How to correctly display data from a range (10:15)

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

vilinyh, 2021-07-25
@Fertehr

select n.NaklID
from Nakl n
join Nakllines nl on n.NaklID = nl.NaklID
where nl.Article in (10, 15)
  and n.Data > '2021-07-20'
group by n.NaklID
having count(distinct nl.Article) = 2

Similar questions

J

Julia2017-06-07 21:43:07

How to calculate a person's center of gravity using Kinect? 6Reply

D

devKazhan2019-11-13 19:12:32

Missing unique pages from the index in favor of someone who steals them? 4Reply

O

Obivankinobi2017-06-24 05:48:52

How to make the correct regularity? 3Reply

D

dfhkjhg2020-12-02 11:54:07

What types to use for the following values? 1Reply

F

freeman02042016-10-15 16:10:58

At what level do you need to know the SQL language if you want to write your own cms using phpmyadmin or something like that? 1Reply

Didn't find what you were looking for?

Ask your question