Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

How to delete completely duplicate rows

Convert varchar to date

sql sql-server database tsql

PostgreSql + Date Format Convert YYYY-MM-DD to Day, Date Month Year

SQL : Test if a column has the "Not Null" property

How does the "With" keyword work in SQL?

Rollback committed data

sql oracle rollback

Use of Like * Works in MS-Access but Not VBA

sql vba ms-access sql-like

How can I set multiple T-SQL variables in a single SELECT query?

sql sql-server-2008 select set

How do you embed sql queries in c#

c# sql entity-framework

How to get a list of recently added stored procs from SQL Server database

can you do an ELSE WHEN on a CASE

sql

Why should I use GO command in sybase?

sql tsql sap-ase

divide the value of a column by another column

sql sql-function

plsql/cursors handle exception and return back to the execution flow

How to use cursor to update record

opposite of "top" in sql server, without using order by, there are no keys/indices

sql sql-server

Round up date field to next half hour in SQL

sql oracle

ORACLE SQL get difference of two values retrieved from 2 select statements

sql oracle select oracle10g

MySQL group by with multiple column sums and a total sum for each group

mysql sql

Find possible duplicates in two columns ignoring case and special characters