Serg

Serg has asked 4 questions and find answers to 40 problems.

Stats

About

Serg questions

VS2019 Winforms SDK-style project, can't add a new form
Android listSelector still partly visible when the item is scrolled out
.Net DownloadFileTaskAsync robust WPF code

Serg answers

SQL to skip max row on condition
SQL SELECT only rows having MAX value of a column from two different tables
Multiple charactor match with LIKE clause
How to check if a set rows is covering the whole time range
Count where value is 1
SQL sum data between 2 dates in one column
How to avoid function repetition in SELECT, GROUP BY, and ORDER BY in SQL
How to dynamically pass in a date_or_time_part for DateDiff?
Put many columns in group by clause in Oracle SQL
How Do I Modify First Digit of Attribute in XML with SQL?