Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

sql: delete a subtree table(id, Parentid) , delete a item with all his children

sql sql-server

How do I delete every row except the last one for each day?

sql mysql

SQL Query Theory Question

sql sql-server query-tuning

cloning a database with backing up possible?

sql sql-server

SQL Server: A Grouping question that's annoying me

SQL Select Count(person_id) > 3 From

Using PHP + VoltDB together?

php sql rdbms voltdb

Ordering Select clause result in specific way

sql database oracle

How to write "WHERE foo = 'bar' OR foo = 'baz' OR ..." without repeating "foo" each time

sql mysql where

MySql to Sql Server migration questions

sql mysql sql-server

Another issue with to_number(). I simply do not understand it

sql oracle ora-01722

How to design SQL tables when column data arrives in multiple types/margins of error?

sql database-design

MySQL Fulltext search always has 0 results?

mysql sql full-text-search

Do I need to run gather_table_stats every time I create an index in order for the Oracle optimizer to use it?

sql oracle indexing

Possible to have an OrderBy in a view?

Creating a user, mapping to a database and assigning roles to that database using SQL scripts

Should I always prefer working with prepared SQL statements, for performance benefits?

Selecting all descendant rows from an Oracle table representing a tree structure

how to fix error when inserting DATETIME into db

java sql derby

Does SQL Server optimize LIKE ('%%') query?