Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

How to check a condition against all the columns of a table?

sql sql-server

Getting distinct values with the highest value in a specific column

mysql - Dynamic column alias

mysql sql

SQL: Computing sum of all values *and* a sum of only values matching condition

What is the best way to handle BOOLEAN values in Db2?

sql db2

Python - Can I insert rows into one database using a cursor (from select) from another database?

Sql Server 2008 sp_executesql syntax help - I think my quotes are not correct

Recursive CTE in presence of circular references

SQL server equivalent of MySQL's "SHOW VARIABLES"

mysql sql sql-server

How Do I Modify First Digit of Attribute in XML with SQL?

sql sql-server xml

How do I revoke (grant drop on any table) from a user?

sql oracle-database

SQL insert ID from IDENTITY ID of the row being inserted

Explicitly lock and unlock a table using ODBC

c++ sql sql-server odbc

(SQL) Delete all rows except the newest one

mysql sql sql-delete

Group and calculate percentages of each distinct value

sql postgresql

SQL selecting datetime values which are 'close' to each other

Select rows where a column is not null if multiple values or null if 1 value

sql sql-server

When using SQL not in function in the where clause, the null values are not returning in the result set

sql sql-server t-sql

Access denied for user 'root'@'localhost' after installing phpmyadmin on ubuntu

php sql ubuntu phpmyadmin