Zane Bien

Zane Bien has asked 3 questions and find answers to 67 problems.

Stats

About

I'm a visual designer, web-developer, and SQL enthusiast originally from Maui, Hawaii and currently based in Los Angeles, CA.

Design Portfolio
LinkedIn Profile

Technical Knowledge:

PHP
SQL
HTML
CSS
JavaScript
jQuery
AJAX
XML

Zane Bien questions

Conditional counting: Performance differences in using SUM() vs COUNT()?
CONCAT(column) OVER(PARTITION BY...)? Group-concatentating rows without grouping the result itself

Zane Bien answers

Deleting random rows from a table without knowing anything about the table ids
Selecting the first row from each group, with ORDER BY more than one column
How to JOIN ON when both tables contain NULL
UPDATE COLUMN from a JOIN
most efficient way of changing order of items in mysql database
Achieve hierarchy, Parent/Child Relationship in an effective and easy way
where table.* <> table.* - Is there a way to do something like this?
SELECT distinct values for multiple rows of same ID
Finding the "exotic" value in a MySQL table
How to find matching time intervals for more than 2 users