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. And there was a lot of Oracle PL/SQL too by my second year, I
2019 November
2010 July
Try something like this:
insert into onTeam(date, player, teamName) select 'newDate','Matt Holliday', teamName from onTeam where player = 'Matt Holliday'
2010 January
- 💬 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.
2009 December
- 💬 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
2008 September
- 💬 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;
