Please can someone give me guidance on how to set up anonymous read-only access to one specific table in Azure. I have a table that I want Power BI students to
There are 163 tables, and I want to add two columns in all. And columns should be added from the front. Please tell me how to do it on postgreSQL This is a tabl
Hi everyone please i need you're help. What i want is when the input field is updated with this value: Résolu --> update column date with date now. I
I'm using Visual FoxPro on my Classic ASP website, and I want to achieve the SQL syntax below to FoxPro version 6. INSERT into users (id, name) VALUES (1, 'jo
This SQL gives me the blog comments that contain just the banned words defined in my table. I only get the EXACT matches and it removes duplicate rows. It also
select if(`num`>99, (select `value` from `sub` where `id`=`main`.`num`), "") as `result` from `main` This all works fine but MySQL is very inefficient as i
select if(`num`>99, (select `value` from `sub` where `id`=`main`.`num`), "") as `result` from `main` This all works fine but MySQL is very inefficient as i
I have the following three tables. See full db<>fiddle here members member_id first_name last_name 1 Roby Dauncey 2 Isa Garfoot 3 Sullivan Carletto 4 Jac
for row in dfp.itertuples(): cursor.execute(''' INSERT INTO players (PID, NAME) VALUES (%s,%s) ''', (row
I have an existing table (jobCost) that has cost data by type and month as shown in the example here. Job Month Material Labor Equip 123 01/1/22 50.00 25.00 75
I want to fetch records from the database as : select * from table where column1 IN (aa, bb , cc...) and column2 IN (34, 55, 66...) and column3 IN(df, fg, hh...
When I run my query, only one of my rows is displayed. I also need to create a database diagram from these 3 tables Can someone please assist me on how to do th
I am currently using Advantage database. I have a table with hundreds of headers. How do I use query to find a specific column name? Example - I am looking for
I keep getting an exception that reads: "Invalid Column Name, 'IBM'." The error is happening at: "' + @ticker + '" even though @ticker is declared in VALUES.
Using Teradata.. I want to write a query that joins table 1 and table 2 on item code to the location in table 2. There are multiple locations per item code and
Lets start with a basic SQL statement like this: SELECT CustomerName, City, Country FROM Customers; We get something like this: CustomerName City Country Alex
I am trying to create a json object from my query using json_build_object as follows: Select json_agg(json_build_object('first_name',first_name,
The following code: SELECT ets.event_id, ets.event_date, dtn.don_date, dtn.don_date - ets.event_date AS date_diff FROM events ets, donation dtn GROUP BY ets.eve
I have a call dataset. Looks like this If a call about a certain member comes in within 30 days of an "original call", that call is considered a callback. I ne
I am trying to add a calculated column that computes a rolling average of a sorted partition. I can make it work as a query but cannot seem to get the result to