TechQA.

Question

STRING_AGG with OVER() clause in SQL Server

score 163 · Answer 1 · 2024-02-05T11:00:05.950000

0

Answer

163

Views

STRING_AGG with OVER() clause in SQL Server

163 views Asked by drk At 05 February 2024 at 11:00

score 125 · Answer 2 · 2023-11-14T14:20:55.357000

Table column aggregation results in the same value duplicating multiple times in one cell

125 views Asked by ThebulletKin At 14 November 2023 at 14:20

score 65 · Answer 3 · 2023-11-07T09:59:01.227000

Subquery and group by : Validation failed: mismatched input 'FROM' expecting <EOF>

65 views Asked by DE_Bytel At 07 November 2023 at 09:59

score 59 · Answer 4 · 2023-11-04T08:04:44.467000

Oracle format String output from Aggregate Collect function

59 views Asked by satya prakash Panigrahi At 04 November 2023 at 08:04

score 81 · Answer 5 · 2023-11-04T07:16:39.873000

Oracle Collect function on Multiple Columns gives Error

81 views Asked by satya prakash Panigrahi At 04 November 2023 at 07:16

score 88 · Answer 6 · 2023-10-19T15:07:51.527000

ORACLE SQL Excluding results within Select (“Result of string concatenation is too long)

88 views Asked by Hugo Sanches At 19 October 2023 at 15:07

score 590 · Answer 7 · 2023-09-30T18:36:50.953000

Snowflake - LISTAGG with LIMIT

590 views Asked by Lukasz Szozda At 30 September 2023 at 18:36

score 61 · Answer 8 · 2023-09-14T12:52:31.120000

How to optimise a query with multiple subqueries for string aggregation?

61 views Asked by zargham ghazanfer At 14 September 2023 at 12:52

score 89 · Answer 9 · 2023-09-04T13:43:21.293000

How do I return identical values between two string aggregated columns in SQL?

89 views Asked by Yosh07 At 04 September 2023 at 13:43

score 145 · Answer 10 · 2023-07-11T10:32:26.833000

SQL: Use STRING_AGG with condition

145 views Asked by Amir saleem At 11 July 2023 at 10:32

score 116 · Answer 11 · 2023-06-20T09:05:59.693000

SQL concatenate row by row by date order with in group

116 views Asked by Mohan.V At 20 June 2023 at 09:05

score 49 · Answer 12 · 2023-05-18T22:54:00.030000

What's the best way to create a string of childIDs for each parentID in SQL, while excluding the current childID from the aggregate

49 views Asked by Mike G At 18 May 2023 at 22:54

score 129 · Answer 13 · 2023-05-16T16:13:43.010000

Question marks appearing in query result when I concatenate values from multiple rows

129 views Asked by Michael Covell At 16 May 2023 at 16:13

score 79 · Answer 14 · 2023-05-16T11:57:02.480000

How to find the column of a specific value in a table (SQL Server)

79 views Asked by Natasha1305 At 16 May 2023 at 11:57

score 65 · Answer 15 · 2023-05-12T15:26:27.680000

SQL - Pivot Column To Rows with Group By and Concat

65 views Asked by Enrico At 12 May 2023 at 15:26

score 36 · Answer 16 · 2023-04-13T19:49:44.087000

Is it possible to use three LISTAGGs and group by elements in row?

36 views Asked by Aaron At 13 April 2023 at 19:49

score 100 · Answer 17 · 2023-04-05T18:53:17.017000

How do I group by values, but only when they're consecutive?

100 views Asked by Leah At 05 April 2023 at 18:53

score 72 · Answer 18 · 2023-03-30T14:39:52.233000

How to concatenate multiple rows

72 views Asked by Arsee At 30 March 2023 at 14:39

score 814 · Answer 19 · 2023-03-28T21:13:40.123000

Concatenate multiple strings ordered (PIVOT)

814 views Asked by GTAMN At 28 March 2023 at 21:13

score 38 · Answer 20 · 2023-03-27T13:50:17.917000

Using "FOR XML PATH" in Databricks Spark SQL in sql syntax

38 views Asked by user9532692 At 27 March 2023 at 13:50

TechQA.

List Question

STRING_AGG with OVER() clause in SQL Server

Table column aggregation results in the same value duplicating multiple times in one cell

Subquery and group by : Validation failed: mismatched input 'FROM' expecting <EOF>

Oracle format String output from Aggregate Collect function

Oracle Collect function on Multiple Columns gives Error

ORACLE SQL Excluding results within Select (“Result of string concatenation is too long)

Snowflake - LISTAGG with LIMIT

How to optimise a query with multiple subqueries for string aggregation?

How do I return identical values between two string aggregated columns in SQL?

SQL: Use STRING_AGG with condition

SQL concatenate row by row by date order with in group

What's the best way to create a string of childIDs for each parentID in SQL, while excluding the current childID from the aggregate

Question marks appearing in query result when I concatenate values from multiple rows

How to find the column of a specific value in a table (SQL Server)

SQL - Pivot Column To Rows with Group By and Concat

Is it possible to use three LISTAGGs and group by elements in row?

How do I group by values, but only when they're consecutive?

How to concatenate multiple rows

Concatenate multiple strings ordered (PIVOT)

Using "FOR XML PATH" in Databricks Spark SQL in sql syntax

Popular Questions

Trending Questions