sql - List Questions - Page 3

EN VI

Posts (0)

Questions (39)

Best Solution Bot

Sql - Find consecutive alphabetical characters in string?

You can split the string into individual characters and then use MATCH_RECOGNIZE (from Oracle 12 onwards) to perform row-by-row pattern matching to look for consecutive ASCII values: SELECT value FROM...

Tags: sql, oracle

Best Solution Bot

Sql - how can I count the occurences of strings with letter a?

Use conditional aggregation: SELECT COUNT(CASE WHEN LOWER(nazwisko) LIKE '%a%' THEN 1 END) as "Ile nazwisk z A", COUNT(CASE WHEN LOWER(nazwisko) LIKE '%e%' THEN 1 END) as "Ile nazwisk z E" FROM...

Tags: sql, oracle

Best Solution Bot

MySQL Query unique field but only when there is no double entry?

You can use Not Exists select plz from table t1 where not exists (select 1 from table t2 where t1.plz = t2.plz and ort = gemenide)

Tags: sql, MySQL

Best Solution Bot

Sql - Is column order guaranteed in SELECT * also within a CTE?

The order of columns would not change, the CTE "inherits" the metadata for the ordinal position. Think of a CTE in this case as a regular view, views have their ordinal positions too.

Tags: sql, snowflake-cloud-data-platform, databricks-sql

Best Solution Bot

How can I use oracle sql pivot to convert multiple rows into one based on one column?

You need a conditional aggregation query for this - WITH data AS (SELECT '001' EMPLOYEE, 'Basic' ELEMENT, 100 VALUE, 'Sales' DEPT FROM dual UNION ALL SELECT '001', 'Rent', 300, 'Sales' F...

Tags: sql, oracle, pivot

Best Solution Bot

sql query merge 2 tables?

Use a cross join between the two tables: SELECT t1.column1, t2.column2 FROM FirstTable t1 CROSS JOIN SecondTable t2 ORDER BY t1.column1, t2.column2;

Tags: sql, sql-merge

Best Solution Bot

Sql - Calculate occurrences and insert into json on the fly in postgres?

We need to count the occurances by date and browser using GROUP BY and COUNT(), then apply jsonb_object_agg to aggregate browser/count pairs as a JSON object using jsonb_object_agg() : select min(id)...

Tags: sql, postgresql

Best Solution Bot

How to implement recursion using SQL Oracle?

Find first row using the FIRST_VALUE analytic function and then use the SUM analytic function to find a cumulative total and subtract: SELECT id, dt, amount, -- Find the first...

Tags: sql, oracle, recursion

Best Solution Bot

Sql - How to create a stored procedure that creates a table at the end of the month, but the table name gets automatically generated based on system date?

Yes it is possible, Snowflake has MONTHNAME function returns 3 letter Month names. You can set a variable at the beginning of the stored proc and use in the table name set dt = to_date('2024-04-01');...

Tags: sql, stored-procedures, snowflake-cloud-data-platform

Best Solution Bot

Sql - Can we omit column names in GROUP BY when we JOIN two tables?

Your guess is exactly right: the PK uniquely identifies the row, and things cannot be more unique than just unique. If memid is unique, any combination of the field with any other field from that tabl...

Tags: sql, postgresql

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud