Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Unexpected result for string comparison

sql sql-server string tsql

SQL Server Weird Grouping Scenario by multiple columns and OR

sql sql-server group-by

Rails 5.2 Error Changing or Removing Table Column (SQLite3::ConstraintException: FOREIGN KEY constraint failed: DROP TABLE)

sql ruby-on-rails sqlite

Not able to convert directly to decimal value?

Why does COUNT(*) require SELECT permission on all table columns on SQL Server?

FTS doesn't work as expected with emails with dots

Inheritance in database?

Display DataType and Size of Column from SQL Server Query Results at Runtime

Is update with nested select atomic operation?

Any good examples/references implementing ACLs via SQL?

sql mysql acl

What is the best way to search an Oracle CLOB column?

sql oracle

The most useful User-Defined Aggregate Functions [closed]

sql aggregate-functions

Can anyone explain me 1NF, 2NF, 3NF, BCNF rules with a proper example?

How to Get Aggregate Data by Time Slice (sum, avg, min, max, etc.) in Rails 3

Find records with exact matches on a many to many relationship

JPA Criteria API: query property of subclass

SQL: Like vs Contains - Different Results

Calculated Member for last-child in non-time dimensions?

sql ssas mdx olap

How can a query with a TOP 10 take infinitely longer to complete than the same query without the TOP 10?

Performance of mysql WHERE ... IN

mysql sql