I have a SQL database, and I am currently using hard-coded credentials in the PHP files. How can I ensure people cannot see these credentials? I have ...

Please see below address and see the solution How to sum two tables with same columns? Please tell me how I can sum three or more tables. Thank you al...

I'm attempting to SELECT a substring from a larger string that should end before the words "STORE" or "PROTECT". The problem is that there are a few s...

Would like the SQL experts to chime in on what the difference between A and B is? A) two different "SELECT COUNT DISTINCT" queries giving different n...

I need an SQL Server query that will list the select rows from the first table and list the related records from the second table on the same row as t...

I am trying to add a column in a SQL query to use as an alternative ID. The data has this format: UserID | Value --------------- 1 | 23 2 | ...

I have a select string as follows: SELECT a.* FROM Table1 a JOIN Table2 cb ON a.LookupId = cb.CBLookupId JOIN Table3 m ON m.Id = cb.Id I want to ch...

I am trying to write a report and the rows need to be grouped in a "special" way. The "BIN" field is where parts are stored on a shelf. One shelf is b...

I have a SQL script that doesn't cause an exception in my C# code. BEGIN TRY BEGIN TRAN INSERT INTO MY_TABLE (COLUMN1, COLUMN2) OUTPUT inserted.ID VA...

I have a csv file which is stored in azure data lake and I want to move it to azure SQL database table. Now my problem is the table has 2 extra colum...

I run this string with result: run sql select telephonenumber, keypadenteredalternateidentifier, n.dnorpattern, userid from enduser, numplan as n wher...

I have a following sample table structure Name Address Name1 Address1 Name2 Address2 I need to get the Name1 but my search criteria is l...

I'm inserting data into the table column whose type is NUMBER(5,2) but when i insert the record it is rounding off the number. I want the number to b...

I got this code from an another stackflow post and it works perfectly. But now i would like to direct the output to a text file as opposed to on the s...

I got this code from an another stackflow post and it works perfectly. But now i would like to direct the output to a text file as opposed to on the s...

I have two tables , for simplification consider these Revenue :- Contains revenue in USD Timestamp id revenue Cell 1 1 100 Cell 2 2 200 ...

I'm new to Oracle PLSQL and I'm finding difficulty to find an exact logic which can convert my json_array _t type of data to a SQL table object type a...

I have a main table that contains the data I have, and a reference table telling me what values the main table should have. I want to check if the mai...

DECLARE orderid NUMBER; customerid NUMBER; channel VARCHAR2(20); amount NUMBER; CURSOR orders_cursor IS SELECT order_id, cu...

In PostgreSQL I have: SELECT * FROM weather_data WHERE parameter_type = 'TEMPERATURE'; I want to write this as: WITH ParameterType AS (VALUES ('TEMPER...

how would one combine these two conditions into the same params map for a query? Post.where('created_at >= ?', 2.weeks.ago) Post.where(:site_id => sit...

COUNTRY STORE_ID ORDER_DATE DE 990003975 2023-01-24 FR 990004963 2023-04-11 FR 990005204 2023-06-15 FR 990005204 2023-06-10 FR 9900052...

SQL Gurus, I have got a problem and I have no idea how to solve it. I have a table like this in BigQuery: id ga_id first_date second_...

I want to create a query in oracle that looks like this DECLARE my_count NUMBER; BEGIN SELECT COUNT(table.column1) INTO my_count FROM table; I...

I am trying to create a column that represents how many days ago the most recent promotion started for each product. It should continue counting on wh...