meta user
network profile
| bio | website | |
|---|---|---|
| location | Ukraine | |
| age | ||
| visits | member for | 1 year, 2 months |
| seen | May 10 at 18:52 | |
| stats | profile views | 39 |
|
Mar 19 |
revised |
Find “n” consecutive free numbers from table added one more demo link, change the other one to use the version 9.1.8, added a note |
|
Mar 19 |
revised |
Find “n” consecutive free numbers from table expanded in response to the question's update |
|
Mar 18 |
revised |
Find “n” consecutive free numbers from table added 44 characters in body |
|
Mar 18 |
revised |
Find “n” consecutive free numbers from table clarified |
|
Mar 15 |
revised |
Update a table field with another table field added additional information from the comments, improved formatting, made table names more consistent |
|
Mar 8 |
revised |
Unique Identifier with Extra Characters Still Matching in Select edited tags |
|
Feb 25 |
revised |
Understanding WAIT_TIME_MS improved formatting and spelling |
|
Feb 2 |
revised |
Dissecting Joins fixed typos |
|
Feb 2 |
revised |
Dissecting Joins expanded explanation using the OP's example |
|
Jan 31 |
revised |
Update Table with Network Client Connection Status, I need help with DB design. SQL 2008 Ex R2 edited tags |
|
Dec 16 |
revised |
How can I correctly choose maximum number of occurrences of a string while grouping by another field? added a version-specific tag |
|
Nov 25 |
revised |
MySQL performance tuning replaced textspeak, fixed some grammar, improved punctuation and formatting |
|
Nov 10 |
revised |
how to calculate difference of first row and last row fields value in each group fixed minor mistakes |
|
Nov 10 |
revised |
Implications of Changing to a Static Port fixed grammar and punctuation |
|
Nov 10 |
revised |
how to calculate difference of first row and last row fields value in each group added the assumed interpretation of "first" and "last" used in the answer |
|
Nov 10 |
revised |
how to calculate difference of first row and last row fields value in each group added SQL Fiddle links |
|
Nov 10 |
revised |
how to calculate difference of first row and last row fields value in each group fixed mistakes in queries |
|
Sep 28 |
revised |
Query from database improved formatting |
|
Sep 27 |
revised |
How can I improve this query incorporated the DDL and the Explain output from Pastebin; added missing capitalisation |
|
Sep 15 |
revised |
query optimization delete nested query improved formatting |
