I have the following scenario: I am trying to pass result of one query to another , In this case I am trying to pass view_id in another query since this are ids they are unique and cant be duplicate…
Please let me know how to get this output, I have searched a lot but all of the queries shows two separate tables one for employees and another department. Here I do not have it so I tried this: SELECT…
Below is the example. BEGIN set tablenameA = 'tablenamelala'; SELECT * FROM table($tablenameA); END I am expecting it will return me the result from the select statement.
I have a table called traffic shown below. I have to write a query which list all the protocols for which incoming traffic is higher than outgoing. The result should be in this format - protocol, traffic_in, traffic_out and sorted…
I have the following 3 MySQL tables. I am storing bookings in the bookings table & the event dates and times in separate MySQL tables. I want to have a MySQL query to list available times for a specific date.…
I am a beginner in SQL and I want to do something on my table 'User'. I would like to make a constraint on my 'Password' column. The constraint is "Passwords only can be made of letters and digits, the…
Some background: I am creating a POS system and have a MySQL Database. The design of my database is one table "tblProducts" is keeping track of product UPC, description, price, etc. The other table "tblStock" is keeping track of quantity,…
I have a table like below, Name Value A Sample1 A Sample2 A Sample3 B Sample3 B Sample1 C Sample2 C Sample3 D Sample1 If I group the table by Name to get the count, Select Name, Count(*) as count…
I have two tables contacts and calllist. contacts has multiple columns containing phone numbers. calllist has only one column from_number containing phone numbers. I'm trying to get all phone numbers from the column from_number which do not match the phone…
I have these two tables: Staff (staffNo(PK), fName, lname, gender, DOB, salary, intTelNo) CarPurchase (purchaseNo(PK), registrationNo(FK), customerNo(FK), amount, date, staffNo(FK)). I need an SQL query to list the names of all male staff who have sold more than 10 vehicles.…