Top "Select" questions

MySQL Nested Select Query?

Ok, so I have the following query: SELECT MIN(`date`), `player_name` FROM `player_playtime` GROUP BY `player_name` I …

mysql sql select group-by nested

comma separated string of selected values in mysql

I want to convert selected values into a comma separated string in MySQL. My initial code is as follows: SELECT …

mysql select comma

SQL Server GROUP BY datetime ignore hour minute and a select with a date and sum value

I have a table with two fields - datetime and int. I want to do a group by on the …

sql-server datetime select group-by

Grant SELECT on multiple tables oracle

I have 3 tables table1,table2,table3. I want to grant(select for example) these tables to a user, user1. I …

select oracle11g grant

I want to vertical-align text in select box

I want to vertically align the text in select box. I tried using select{ verticle-align:middle; } however it does not …

css gwt select vertical-alignment

SQL alias for SELECT statement

I would like to do something like (SELECT ... FROM ...) AS my_select WHERE id IN (SELECT MAX(id) FROM my_…

sql select alias

Ordering by specific field value first

I have a table with 3 columns: id | name | priority -------------------- 1 | core | 10 2 | core | 9 3 | other | 8 4 | board | 7 5 | board | 6 6 | core | 4 I want to order …

mysql sql select sql-order-by

How to create virtual column using MySQL SELECT?

If I do SELECT a AS b and b is not a column in the table, would query create the "…

php mysql select

SQL: How To Select Earliest Row

I have a report that looks something like this: CompanyA Workflow27 June5 CompanyA Workflow27 June8 CompanyA Workflow27 June12 CompanyB Workflow13 …

sql date select subset

What is the difference between Select and Project Operations

I'm referring to the basic relational algebra operators here. As I see it, everything that can be done with project …

sql select relational-algebra