I was helping my brother check some database issues the other week, and he mentioned how impressed he was with how quickly I was able to come up with SQL queries on the fly. I told him that SQL was one of the skills I considered myself to have mastery over. This shouldn’t be surprising given my early career path:
for most of my first year working as a software developer, I was working on reports which involved lovingly handcrafted (and oftentimes quite complicated) SQL queries.
All entries tagged sql.
You can subscribe to an RSS feed of this list.
Nov 2019
Sep 2013
Jul 2010
-
Try something like this:
insert into onTeam(date, player, teamName) select 'newDate','Matt Holliday', teamName from onTeam where player = 'Matt Holliday'
Jan 2010
-
Reply to 'Mysql: Which to use when: drop table, truncate table, delete from table' on stackoverflow:
In addition to the answers above, on Oracle RDBMS, “delete” is a transaction that can be rolled back if you didn’t commit. “Truncate” cannot.
Dec 2009
-
Reply to 'SQL Help (For Each)' on stackoverflow:
If you want the average salary for all records AND a listing of the name column for each record, you need to use 2 separate queries
Sep 2008
-
Reply to 'Add a column to existing table and uniquely number them on MS SQL Server' on stackoverflow:
for oracle you could do something like below
alter table mytable add (myfield integer); update mytable set myfield = rownum;