Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

MySQL Order By Number of Matches

mysql sql select sql-order-by

Database Design: Index Varchar

mysql variable assignment : how to force assignment order?

sql mysql variables

Query Excel using ADO from VB.NET when a column name is a number

sql vb.net excel ado

Trying to find a good picture/diagram of SQL Server security: logins, roles, etc

sql sql-server security

Returning unique results in a joined select

sql t-sql unique distinct

SQL: Left Outer join that can switch what columns to join with depending on data inside the column

SQL check if all values of bool are true by group

sql sql-server

Using a WHERE clause subquery, select the greatest 1 per group with a tie-breaker

Optimize JPA dynamic count query

Compare Postgresql timestamp to timezone in sql query in django

Oracle sequence generation based on the columns present in the same table

Dynamic casting when using pivot

trim leading zeros in impala

sql cloudera impala

Converting to float: CAST vs CONVERT vs *1.0

sql, javax.persistence.criteria: check a database table column with comma separated string values against a list of strings

java sql database postgresql jpa

Is it better to join two fields together, or to compare them each to the same constant?

sql join

I traced a Stored Procedure as shown in the SQL Server 2005 Profiler. It's not found but works. Why?

Whats a good value for 'identity increment' for an 'Orders' table

sql