Zane Bien

Zane Bien has asked 3 questions and find answers to 71 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

How do you get the comment count of the post through mysql query?
SQL joining multiple tables on single column
Searching multiple columns in SQL for value vs storing in one column
Comparison in MySQL SELECT
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