Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Any better Fibonacci series generator using pure Oracle SQL?

How to cast LONG to VARCHAR2 inline

sql oracle oracle12c

Passing parameters to raw SQL queries inside ruby on rails

BigQuery GroupBy with STRUCT

sql google-bigquery

Spark Scala : Getting Cumulative Sum (Running Total) Using Analytical Functions

Athena date_parse for date with optional millisecond field

sql amazon-athena presto

psycopg2 - Using SQL object with execute_values

How can I prevent integers being silently turned to asterisks in SQL Server?

sql sql-server

Does field size affect query time?

mysql sql database

What does "%%DatabaseEx" do in TSQL?

What is the difference between group by, distinct, Union for selecting distinct values for multiple columns?

sql group-by union distinct

Search column in SQL database ignoring special characters

Split a VARCHAR in DB2 to retrieve a value inside

sql string db2 split

entity framework entity sql vs linq to entities

sql entity-framework

Mysql: Optimizing finding super node in nested set tree

sql mysql nested-sets

Oracle - Return shortest string value in a set of rows

sql oracle plsql

How to tune a 7-table-join MySQL count query where tables contain 30,000+ rows?

sql mysql count performance

Conditional Where statement on a table valued parameter?

How to do bitwise exclusive OR in sql server between two binary types?

sql sql-server tsql

Error restoring database backup to new database with smo and powershell