RSS feed [root] /weblog /database /sql




login:

password:

title search:




 


Thu Apr 06 06:32:45 GMT 2023

sql



(google search) (amazon search)
second
download zip of files only

Mon Jun 17 00:30:14 GMT 2019 From /weblog/database/sql

join


http://www.codeproject.com[..]33052/Visual-Representation-of-SQL-Joins http://nosql.mypopescu.com/post/51770099382/sql-joins-visualized

With IN and subquery / or "top" like keywords - http://javarevisited.blogspot.com.au[..]econd-highest-or-maximum-salary-sql.html

Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot
- https://dev.to[..]-database-for-beginners-best-of-lot-5533

(google search) (amazon search)


Fri Jan 22 03:39:27 GMT 2016 From /weblog/database/sql

grouping


There is way to drop the dummy aggregate function in group by - http://blog.jooq.org[..]onal-dependencies-a-very-useful-feature/

(google search) (amazon search)


Mon Jan 13 04:24:11 GMT 2014 From /weblog/database/sql

Problem of SQL


A nice article to talk about problem of SQL. Although we probably need to live with SQL or abstraction of SQL (various OQL and ORM QL), it still nice to know about this

http://www.oreillynet.com/lpt/a/6060

How to simulate column reuse, which is missing from standard SQL - http://blog.jooq.org[..]/the-sql-languages-most-missing-feature/

(google search) (amazon search)


Fri Apr 29 06:41:53 GMT 2011 From /weblog/database/sql

time


Function that convert string to timestamp for mssql, oracle and sybase - http://connectsql.blogspot.com[..]ql-server-basics-todate-function-in.html

(google search) (amazon search)


Tue Jan 11 00:46:00 GMT 2011 From /weblog/database/sql

xml


manipulate xml in sql server - http://www.15seconds.com/issue/050803.htm

(google search) (amazon search)


Sat Mar 21 10:54:47 GMT 2009 From /weblog/database/sql

except


example of except keyword - http://sqlblog.com[..]rence-between-two-sets-of-like-data.aspx

(google search) (amazon search)


Mon Oct 15 11:32:55 GMT 2007 From /weblog/database/sql

ansi joining


A nice article about standard ANSI joining syntax:

http://www.oracle.com/technology/oramag/oracle/01-nov/o61sql.html

Recognizing well known patterns involving outer joins will form a ground-level vocabulary for your further explorations of your data. This article examined syntax, surprises, and rules of thumb with respect to the usage of joins.

http://www.onjava.com/lpt/a/4443

A blog with nice graphic show how join work - http://www.codinghorror.com/blog/archives/000976.html

(google search) (amazon search)


Wed Jun 13 15:34:34 GMT 2007 From /weblog/database/sql

solve sudoku in sql


A very complicate TSQL sample... in my opinions: http://www.vsj.co.uk/articles/display.asp?id=540

Even more implementation - http://lambda-the-ultimate.org/node/2291

which introduce some interesting function in vendor specific SQL, like Oracle MODEL - http://download-uk.oracle.com[..]erver.102/b14223/sqlmodel.htm#sthref1855

(google search) (amazon search)