I am using MySQL Workbench. I am trying to build a table with random dummy data that I am generating using a loop. I want to loop through 100 columns which are named 1-100. How can this be accomplished? Here…
Let's say I have a table with Columns A, B, C, D, E and F. How would I query for entries where (A, B, C, D, E, F) = (1, 2, 3, 4, 5, 6) but only a subset of…
Given a data set of orders, I want to be able to get the distributors ranked in the top 200 based on the total amount of sales generated such that users having the same (total sales) figure are ranked equally:…
I tried this but how to calculate for leap years. SELECT FLOOR(DATEDIFF(NOW(), date_of_birth) / 365.25) as years, FLOOR(MOD(DATEDIFF(NOW(), date_of_birth), 365.25) / 30.4375) as months, MOD(DATEDIFF(NOW(), date_of_birth), 30.4375) as days FROM employees; Can anyone please help
I have the below query in mysql, when I run the query, it gives me the complete report and "where clause does not work" SELECT oo.dateaccessioned AS 'Date', oo.barcode AS 'Acc. No.', ooo.title AS 'Title', ooo.author AS 'Author/Editor', concat_ws(' ,…
I'm trying to query for users with birthdays falling between a given date range. The users table stores birthdays in a pair of int columns: dob_month (1 to 12) and dob_day (1 to 31). The date range I'm querying with…
I am relatively new to SQL and I am trying to extract rows where they have the highest values. For example, the table look like this: user_id fruits 1 apple 1 orange 2 apple 1 pear I would like to…
table img SELECT namaline, shift1 FROM semualine WHERE cektelatshift1 <> 'Ontime' UNION SELECT namaline, shift2 FROM semualine WHERE cektelatshift2 <> 'Ontime' UNION SELECT namaline, shift3 FROM semualine WHERE cektelatshift3 <> 'Ontime'; namaline shift1 Line 1 Shift 1 Line 2 Shift…
I have a sequelize model called staff. One of the staff columns is called locations which holds the id's of all the locations this staff is available at. I want to create a query that uses a Location ID to…
I need to put a constraint which will restrict DUPLICATE entries in combination of 2 columns. So I have a customers table, with the below mentioned columns id, first_name, last_name, date_of_birth, gender, email_address, primary_number, secondary_number. What I am expecting is…