Skip to content

Tag: mysql

Laravel SQL Query. Help me

I have a table name “Offers” with 3 (public, request, private ) types of data. Now I want to show directly to the user end public and request offers. and private offers not be shown but when admin …

Simple SQL query returning null value

I just started studying SQL queries. I am practicing on this site: https://www.techonthenet.com/sql/joins_try_sql.php I want to find: “the name of the employee with the highest salary for every department”. My query is: And I get null value for first_name : I understand that the problem is due to …

Pairing table query

I was wondering how I construct a query to get all articles with all their information, and for every article a list with their tags. I used a pairing table called ArticleTags to connect Article and Tags. Can anyone tell me what the query would be if I wanted to receive all articles along with their tags per …

MySQL self join to find only the next revision

Actually I’m working with WordPress. I want to create a self-join or something similar to find a revision of a post, and the following revision of the same post. https://www.db-fiddle.com/f/eHnwYABYrVVQAhn8xLJ77q/1 The previous query doesn’t work since it takes, for every record of a, all the revi…

How to SELECT DISTINCT *

Is this a possible query? Currently, every product from my database is being listed on the home page of my website and a lot of them are duplicates since a product can belong to multiple categories. I am using “SELECT * FROM Books WHERE product_status = ‘1’”; Answer Then use group by a…