What is the difference between HAVING and WHERE in an SQL SELECT statement? EDIT: I have marked Steven’s answer as the correct one as it contained the key bit of information on the link: When GROUP BY is not used, HAVING behaves like a WHERE clause The situation I had seen the WHERE in did not have GROUP BY and
How can you find the number of occurrences of a particular character in a string using sql?
How can you find the number of occurrences of a particular character in a string using sql? Example: I want to find the number of times the letter ‘d’ appears in this string. declare @string varchar(…
How to “select until” a sum is reached
I’m looking for a way to select until a sum is reached. My “documents” table has “tag_id” and “size” fields. I want to select all of the documents with tag_id = 26 but I …
How do I alter the position of a column in a PostgreSQL database table?
I’ve tried the following, but I was unsuccessful: ALTER TABLE person ALTER COLUMN dob POSITION 37;
How to set a default row for a query that returns no rows?
I need to know how to return a default row if no rows exist in a table. What would be the best way to do this? I’m only returning a single column from this particular table to get its value. Edit: …
How to create relationships in MySQL
In class, we are all ‘studying’ databases, and everyone is using Access. Bored with this, I am trying to do what the rest of the class is doing, but with raw SQL commands with MySQL instead of using Access. I have managed to create databases and tables, but now how do I make a relationship between two tables? If I
Is RIGHT JOIN Ever Required?
Do any queries exist that require RIGHT JOIN, or can they always be re-written with LEFT JOIN? And more specifically, how do you re-write this one without the right join (and I guess implicitly …
coalesce alternative in Access SQL
In T-SQL, you can do this: SELECT ProductId, COALESCE(Price, 0) FROM Products How do you do the same thing in Access SQL? I see examples for doing it with Nz in VBA, but I’m looking for the SQL …
Is it possible to execute a text file from SQL query?
I have a number of generated .sql files that I want to run in succession. I’d like to run them from a SQL statement in a query (i.e. Query Analyzer/Server Management Studio). Is it possible to do something like this and if so what is the syntax for doing this? I’m hoping for something like: I am using SQL Server
How do you OR two LIKE statements?
I have tried the following two statements: SELECT col FROM db.tbl WHERE col (LIKE ‘str1’ OR LIKE ‘str2’) AND col2 = num results in a syntax error SELECT col FROM db.tbl WHERE page LIKE (‘str1’ OR ‘…