Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

How to prevent deletion from happening using triggers?

sql oracle

Cursor inside SQL query

Is a query with intersect equivalent to those 'where a and b'?

sql postgresql

Computed Column (COALESCE vs CASE vs ISNULL)

Linq to Sql, System.Exception cast is not valid

sql linq asp.net-mvc-2

Select highest record of type per foreign key

mysql sql

How to make an efficient check constraint for an e-mail field in Firebird

sql firebird

JOOQ insert into select syntax with specified columns

java sql select insert jooq

TSQL: if statement inside a select insert

Passing numeric variable and preventing SQL injection

How to INSERT using SELECT on Table and Query

sql ms-access

How to get week-wise data in Oracle

sql oracle

What does "=?" represent when used in an SQL query

java sql jdbc syntax

Test ALL rows exists

sql exists

Does two queries, one with OR and one with IN(), have the same performance?

sql performance

Strange length restriction with the DB2 LIKE operator

sql casting db2 sql-like varchar

Getting count of different records from single table-MySQL

mysql sql count

Finding multiple attribute from GROUP BY function in a Query

sql database oracle

Something equivalent to "SELECT * FROM (SELECT table_name FROM...)"?

mysql sql dynamic-sql mysql5

SQL - Updating rows based on reference data in lookup table

sql sql-server