Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

How to remove all special characters from a column name string using regular expressions

sql sql-server regex t-sql

SQL Server adding two time columns in a single table and putting result into a third column

sql sql-server-2008 time

HIVEql statement for listing all available functions

sql hive hiveql

Delete Top 10 record from table

mysql sql database

SQL Select Distinct with Conditional

sql mysql

How to insert into a table from temp table?

How to change the column order of an Azure database table in Visual Studio

Lock specific table rows to insert a new row

postgresql change character varying to character varying array

sql postgresql

SQLFetch() fails with the SQLState 24000 (Invalid Cursor)

Why do we need a Rollback command while making a transaction or tell me a when is it appropriate to use "ROLLBACK"

sql sql-server

Is there simple way to get query for dbix::class result?

sql perl dbix-class

Parsing Insert SQL Query in Java using Regular Expression

java sql regex

Limiting output of rows based on count of values in another table?

sql

How to perform stratification based on a column in Snowflake

H2 database: unique constraint only over non-NULL values? (filtered index)

sql h2

Is ORDER BY stable for several rows with the same key values?

sql postgresql sql-order-by

Select from PostgreSQL function that returns composite type

SQL select from a select query

sql sql-server

SQL 'CASE WHEN x' vs. 'CASE x WHEN' with greater-than condition?

sql sql-server t-sql select