I have a table which consists of multiple columns. Table consists of data like Group no Maxtime Updatedtime A22 20221502 20221702 A22 20212502 20221702 A22 20212502 20221702 I query that table with a condition like Select Group no from cnt…
I have a vehicle table with many rows. Every vehicle is stored with a name, and then additional characterizing attributes. Let's say name PRIMARY KEY attr_1 attr_2 attr_3 attr_4 etc... The user can search via a web form by name…
Essentially, I am trying to group customer names and then sort by transaction date in ASC order and then only get the first two transactions (LIMIT 2) SELECT customer_names, transaction_date FROM Customer ORDER BY customer_names, transaction_date LIMIT 4 What would…
I wrote the below query with a CTE attempting to return all the dates on which daily transactions exceeded the average of all daily transactions; however, MySQL keeps returning an error message for something around line 1. I've attached a…
I have to write a query which will return the latest timestamp column's value from a table if rows exist. If there is no row(s) in table then it return the default value. I have write the following query in…
I want to select all package_id that contain product_id 2. In this case, package_id 1,3,5 has product_id 2 Table: product_package package_id package_name product_id --------------------------------------------- 1 Gold 1,2,3 2 Platinum 4,5,12 3 Diamond 2,11,5 4 Titanium 3,5 5 Basic 2 I…
i tried to use subquery to show JOB_TITLE in the result this code work , but i can't add JOB_TITLE 'Jr. Designer' in the result select EMP_ID,F_NAME,L_NAME from employees where job_id in (select job_ident from jobs where JOB_TITLE= 'Jr. Designer');
I was trying to insert values to MySQL database with following code: $pdo = new PDO('mysql:host=localhost;dbname=project;charset=utf8;, 'admin', 'password'); $stmt = $pdo->prepare('INSERT INTO userdata values(?, ?, ?, ?, ?)'); if ($stmt->execute(null, '"'.$_REQUEST['username'].'"', '"'.$_REQUEST['password'].'"', '"'.$file.'"', null)) { echo 'Inserted' } else {…
I want to calculate average customers will order but when i calculate there's have a problem, mine is: SELECT CustomerID, (MAX(SalesDate) - MIN(SalesDate)) / (COUNT(*) - 1) FROM TrSalesHeader GROUP BY CustomerID HAVING COUNT(*) > 1 and i've message "Operand…
SQL query for extracting last entered number field(if we enter 11 in 3 rows take last row) from a table.Consider the following table I want to show result like this