I need to write a SQL statement to find the ‘Action’ (category) films with the shortest running time (length). Your query should output the titles and lengths of the films. This is the database schema I have. I created 3 tables and inserted some records on these tables. I write my query like this: But there a…
How do I fix the error that occurs when I enter the file path and date in mysqldump?
How do I fix the error that occurs when I enter the file path and date in mysqldump? I ran the mysqldump command as follows in cmd: set _my_datetime=%date:-=% mysqldump -u root -p –all-databases -pMyPassword > C:Program FilesMariaDB 10.4databackup%_my_datetime%.sql But the result is: I wonder how to …
Dynamic LIKE in WHERE clause in T-SQL with STUFF and FOR XML Path
What I’m trying to do is search a text column for anything LIKE anything in a list of values. The table with the text column is very large, so I can’t join on LIKE ‘%’ + valuename + ‘%’ (the list of values temp table is not terribly large). I thought I would try to do it th…
How can I select multiple columns while using “when” statement
Here is the syntax I wanted to use for “loan amount” column. I am creating a data set on ssas for reporting. But I am having a problem adding “loan id” column based on the syntax since I need both “loan amount” and “loan ID” in the same data set. How can integra…
How to split comma delimited data from one column into multiple rows
I’m trying to write a query that will have a column show a specific value depending on another comma delimited column. The codes are meant to denote Regular time/overtime/doubletime/ etc. and they come from the previously mentioned comma delimited column. In the original view, there are columns for each…
After creating a role with grant update user1.table1, I gave grant role to user2, when executing the update I received Error ORA-01031
After creating role RL_WRITE and granting the grant update to table user1.table1 to role and granting role to user2 I get insufficient privileges error. CREATE ROLE RL_WRITE; GRANT UPDATE ON user1….
How does postgresql’s crypt() function know that a password matches a stored one?
I am learning to use crypt() function from pgcrypto to crypt my passwords and store them into user tables. However I don’t understand how it is possible for the crypt function to generate the same password if we pass as a second parameter the existing password. I want to understand how it does it please…
Cascading combo box
I am trying to bind 2 combo box, being the value of the second dependent from de first. All the solutions that i saw to this problem were by the use of Sql.Data (Datatable), which i cant use, due to the architecture of the application. I can do it 2 ways, by c# or through ASP Object Data Source. I’ve
What will be the output of the left join? [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question. Closed 8 months ago. Improve this question I ha…
Subqueries in MySQL
My first post here and I am desperate. Need this to complete the last 2 questions of my assignment. This is the code I wrote and it is outputting almost what I need. The problem in the assignment wants to display Employees or Guests that are from Winnipeg or London. My code gives me all the cities for each em…