McNets's user avatar
McNets's user avatar
McNets's user avatar
McNets
  • Member for 7 years
  • Last seen more than a week ago
30 votes
Accepted

Try catch equivalent in Postgres

21 votes

Constraint - one boolean row is true, all other rows false

21 votes
Accepted

Cannot drop column : needed in a foreign key constraint

21 votes

Where can I find the first standardization of SQL, SQL-86?

21 votes
Accepted

Strange JOIN ON clause in T-SQL

20 votes
Accepted

get only rows with max group value

19 votes
Accepted

Postgresql To Return 0 when Null

14 votes
Accepted

Using outer alias in a subquery

14 votes
Accepted

How to do SUM() but with some rules to follow?

14 votes

Select multiple values in LIKE Operator

13 votes

Last time of trigger execution

13 votes
Accepted

TOP (100) PERCENT when designing a view

12 votes
Accepted

POSTGRES declaring variable containing date array in functions

12 votes

Best practices to maximize portability in SQL Server 2016

12 votes
Accepted

Is it possible to PIVOT on a LIKE statement

11 votes

How to get a group where the count is zero?

11 votes

NULL value causes blank row in SELECT results for text concatenation

11 votes
Accepted

SQL SERVER: Create table with named default constraint

10 votes
Accepted

Best design to reference multiple tables from single column?

10 votes

What is the best way to rebuild a date from integer inputs?

10 votes
Accepted

How to change definition of a Postgres GENERATED (stored) column

9 votes
Accepted

Advice on T-SQL script, change to use dynamic SQL

9 votes
Accepted

NonClustered Index not being Used

9 votes
Accepted

Can SQL Server 2016 extract node names from JSON?

9 votes
Accepted

LEFT JOIN Producing Inflated COUNT() numbers

9 votes
Accepted

Add business days in PostgreSQL

8 votes
Accepted

SQL Server JOIN not working

8 votes

how to increase column values by 20 percent using mysql

8 votes
Accepted

postgres simple number to string mapping

8 votes
Accepted

PostgreSQL select count with dynamic date range

1
2 3 4 5
24