Question : **OrdersTable** OrderID Product SELECT OrderId, Product FROM OrdersTable WHERE Product = ‘ProductA’ AND Product = ‘ProductB’ –doesn’t work […]
Tag: relational-division
How to write “and” queries for a lookup table when you can’t use the AND keyword?
Question : I’m building a practice website that allows users to search hotels based off of the amenities that the […]
SELECT rows based on indefinite number of filters
Question : How do I create a function which takes indefinite parameters? And then finds all game_ids in a table […]
Matching a value with every element of a set of values – Postgresql
Question : I’m new in Postgres and I can’t achieve what I’m trying to do. I have a list of […]
how to get a single row based on my condition
Question : I have following rows in my user table as Now I want to get user having all accesstype […]
PostgreSQL find groups with same members
Question : Given the following schema: User id Group id Membership group_id user_id (With a unique index on group_id, user_id) […]
MySQL Using AND Statement
Question : I am having issues with this question: Find the cities that have direct (non-stop) flights to both Honolulu […]
SQL query to display names of customers who have purchased all the DVD
Question : These are the tables I have created and inserted the values accordingly: CREATE TABLE Customer (Customer_No INTEGER IDENTITY […]
A better way to write this query?
Question : I have the following schema for my database (Postgresql 10): CREATE TABLE “PulledTexts” ( “Id” serial PRIMARY KEY, […]
Finding two users with same pair group
Question : I have the following table which details actions of users and the action’s parameters: action_id(auto-increment) | user_id | […]