Let’s say my sql dataset looks like this and it has one column: John John,2345 Joe,1234 Joe Joe,1234 John John,2345 John,2345 Smith Smith I am going to count the number of times …
Tag: sql
Where should I modify?
This is an oracle sql. SQL servel says “there is no USERS Table” but user table exists in my db. Answer You don’t need the table name.
Truncate if exists in psql function and call function
I have the following code to create a function that truncates all rows from the table web_channel2 if the table is not empty: create or replace function truncate_if_exists(tablename text) returns void …
SQL GroupBy for Stored Procedure caused Error
I have a quick question that why my SQL Stored Procedure did not work properly. Can someone explain what is wrong with my Stored Procedure Query? Error: “Each GROUP BY expression must contain at least one column that is not an outer reference.” Answer It can never work the way you are trying it, b…
SQL aggregate function on result of another aggregate function
Short backstory for this question. I am a student who works part-time as a tutor for several classes, including an entry level SQL class. I’ve got a student who has a fairly complicated database, compared to what most people get out of this class. Since their database ins’t super simple, they̵…
Dummy Column in SQL Query
I am working on a SQL query and I need to do a calculation and store the result in dummy column in the output. I am doing the calculation as shown above however I am still missing something. Any help will be greatly appreciated. Answer SQL doesn’t allow for you to do computation on data being computed i…
How to write multiple queries in a single tables.sql file and upload it using PHP?
All I want is to create 2 or more tables using tables.sql file via PHP. PHP create_db.php DB_HOST, DB_USER, DB_PASSWORD, DB_NAME are defined in config.php file PHP v7.4.7 SQL tables.sql If I upload this tables.sql file directly to MySQL server using command line it is working. MySQL v8.0.20 MySQL Comunity Ser…
SQL How to flag a given sessionID based on values from another column
Forgive me I’m not massively familiar with SQL to do the below. But would love to learn the process of how to do it if possible. I only have one table: Table name – SessionTracker I’d like to From the example above: I want to check is if a session which consists of request, event & respo…
Create a column based on conditions in select statement
I have an order table in Postgres with order number and status as column. If a new order is placed the default status were Order placed and Goods Assigned. order 12345 order 543223 I want to know if the order were out from the sender place. So I want to create a column called started and has value Yes if
SQL Where data is equals to 2 different values
I have the following query: I want to return rows where reservation is anything EXCEPT ‘no-show’ or ‘removed’ Right now it’s returning rows still that are ‘removed’ I ran the command directly in sql and the same problem 🙁 Answer Use NOT IN: You seem unfamiliar with th…