Why are there extra spaces between my month and day? Why does’t it just put them next to each other? So your output will be aligned. If you don’t want padding use the format modifier FM: SELECT TO_CHAR (date_field, ‘fmMonth DD, YYYY’) FROM …; Reference: Format Model Modifiers
Here is what you want SELECT title, time FROM table GROUP BY title, time HAVING count(*) > 1
You can use a CASE expression with your aggregate to get a total based on the outcomeId value: select companyId, sum(case when outcomeid = 36 then 1 else 0 end) SalesCount, sum(case when outcomeid <> 36 then 1 else 0 end) NonSalesCount from yourtable group by companyId; See SQL Fiddle with Demo
Backing up/Exporting database There are two ways to Back up/Export a SQL Server database using SQL Server Management Studio: Right click database → Tasks → Generate Scripts → Choose DB → Change “Script Data” option to true → … Right click database → Tasks → Backup → … The first method creates a .sql file … Read more
To help guard against SQL injection, I normally try to use functions wherever possible. In this case, you could do: … SET @TableName=”<[db].><[schema].>tblEmployees” SET @TableID = OBJECT_ID(TableName) –won’t resolve if malformed/injected. … SET @SQLQuery = ‘SELECT * FROM ‘ + QUOTENAME(OBJECT_NAME(@TableID)) + ‘ WHERE EmployeeID = @EmpID’
CodeIgniter’s ActiveRecord doesn’t support UNION, so you would just write your query and use the ActiveRecord’s query method. $this->db->query(‘SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2’);
You have missed out the field name id in the second NOT LIKE. Try: SELECT * FROM transactions WHERE id NOT LIKE ‘1%’ AND id NOT LIKE ‘2%’ The AND in the where clause joins 2 full condition expressions such as id NOT LIKE ‘1%’ and can’t be used to list multiple values that the … Read more
The easiest way is to not store the count, relying on the COUNT aggregate function to reflect the value as it is in the database: SELECT c.category_name, COUNT(p.post_id) AS num_posts FROM CATEGORY c LEFT JOIN POSTS p ON p.category_id = c.category_id You can create a view to house the query mentioned above, so you can … Read more
Applying normalization to your problem, the solution is as given. Run and see it on SQL Fiddle. CREATE TABLE products ( product_id int AUTO_INCREMENT PRIMARY KEY, name varchar(20), description varchar(30) ); INSERT INTO products (name, description) VALUES (‘Rug’, ‘A cool rug’ ), (‘Cup’, ‘A coffee cup’); — ======================================== CREATE TABLE variants ( variant_id int AUTO_INCREMENT … Read more