SQL Group By only incude distinct entries not previously in table
sql,sql-server,select,group-by,exclusion
One way to do this is to select the minimal year for each user, and then count those: SELECT YearCreated, COUNT(*) FROM (SELECT UserId, DATEPART(year, MIN(DateCreated)) AS YearCreated FROM users GROUP BY UserId) t GROUP BY YearCreated ...
How can get this function to exclude certain values?
I have cleaned up your query a bit: SELECT Artist.artName, AVG(CD.cdPrice), Count(*) FROM CD INNER JOIN Artist ON Artist.artID=CD.artID WHERE Artist.artGenre NOT LIKE "%Electronica%" GROUP BY Artist.artID In your original query you had WHERE Artist.artID = CD.artID, which is totally unnecessary since you already specified this in the JOIN. Also...
inclusive exclusion in regular expression
You need to use the end of the string anchor: \d{2,3}\/folder1\/subfolder1\/subfolder2\/(?!18$)\d or a slash or another character if your string is only a substring (not at the end): \d{2,3}\/folder1\/subfolder1\/subfolder2\/(?!18\/)\d ...
Maven Profile does not run appropiate tests
You have not reconfigured the surefire run, but instead added another one to the lifecycle. That way, surefire:test runs twice, once with default execution id (default-test) and once with your new execution (integration-test) If you simply want to change the tests being run, you could use: <profile> <id>integration</id> <build> <plugins>...