In an SQL script, how to get one line by clientid with the most current period end and discard the rest - thank you
|
|
1
|
221
|
April 27, 2023
|
How to split a string with special text from SQL column?
|
|
7
|
575
|
April 24, 2023
|
Cursor returns also empty records
|
|
3
|
557
|
April 21, 2023
|
Query performance help
|
|
4
|
237
|
April 21, 2023
|
XML replace Value
|
|
1
|
285
|
April 20, 2023
|
Copy table to new empty talbe with indexes and identity
|
|
14
|
1437
|
March 24, 2023
|
Window Function SQL Help! Grouping
|
|
2
|
217
|
April 17, 2023
|
Create sequence
|
|
4
|
397
|
April 15, 2023
|
Finding the month over month and year over month comparison metrics
|
|
1
|
253
|
April 14, 2023
|
Table with incorrect data in columns
|
|
3
|
219
|
April 14, 2023
|
SQL query how to take out the average weight for the column
|
|
9
|
809
|
April 13, 2023
|
Database schema and permissions
|
|
3
|
197
|
April 13, 2023
|
How can i alter two views in one sql statement using SQL Developer
|
|
4
|
219
|
April 11, 2023
|
Need to create a .xml file in a specific format
|
|
0
|
186
|
April 8, 2023
|
SAST Free tool for SQL server
|
|
3
|
1066
|
April 6, 2023
|
SQL Query to PIVOT? data
|
|
1
|
193
|
April 6, 2023
|
Query help in join
|
|
4
|
352
|
April 5, 2023
|
How to handle two tables with common ID but no matching records?
|
|
6
|
179
|
April 4, 2023
|
SQL or Excel
|
|
11
|
568
|
April 4, 2023
|
Get TimeStamp on value of other columns value changed from 1 to 2
|
|
6
|
187
|
April 3, 2023
|
Tricky query
|
|
5
|
262
|
March 31, 2023
|
Select all data into a new table in a different DB
|
|
6
|
152
|
March 31, 2023
|
Query last 7 days on Unix timestamp column
|
|
5
|
845
|
March 31, 2023
|
Finding the sum of sales and returning the max of name
|
|
1
|
195
|
March 30, 2023
|
Splitting column to as many columns as needed by delimiter
|
|
4
|
2136
|
March 30, 2023
|
Count events by ID
|
|
4
|
281
|
March 30, 2023
|
Removing Spaces in MIDDLE of a Column - Resolved
|
|
2
|
457
|
March 28, 2023
|
Update from a Set Select Statement
|
|
3
|
174
|
March 27, 2023
|
Retrive data from multiple colum
|
|
1
|
504
|
March 27, 2023
|
BCP utility - line terminator for row
|
|
2
|
439
|
March 25, 2023
|