Assuming data is required, the following 228 results were found.
include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM a_pretend_table WHERE a_condition=true )...
next Friday -- 2012-05-04 -- next Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both saturday and sunday returned week ending date...
Drop If Object Existshttps://joellipman.com/articles/database/t-sql/drop-if-object-exists.html
but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some...
had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the...
Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html
the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME,...
VersionPlatform ChangeLogOptions1.0+ Group all the data by a specified column + Generate interactive flash charts - Date Uploaded: Wed, 15th Sep 2010 Download
on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns......
to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just...