57
votes
14
answers
989
views
How do I escape a single quote in SQL Server?
I am trying to insert some text data into a table in SQL Server 9. The text includes a single quote '. Ho
54
votes
30
answers
1.2K
views
Retrieving the last record in each group - MySQL
There is a table messages that contains data as shown below: Id Name Other_Columns ----------------------
65
votes
14
answers
3.1K
views
How do I limit the number of rows returned by an Oracle query after ordering?
Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this:
50
votes
24
answers
1.7K
views
Get list of all tables in Oracle?
How do I query an Oracle database to display the names of all tables in it?
57
votes
6
answers
2.6K
views
Difference between JOIN and INNER JOIN
Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = otherTable.
60
votes
14
answers
3.1K
views
SQL Server - Best way to get identity of inserted row?
What is the best way to get IDENTITY of inserted row? I know about @@IDENTITY and IDENT_CURRENT and SCOPE_IDE
65
votes
3
answers
2K
views
Using group by on multiple columns
I understand the point of GROUP BY x. But how does GROUP BY x, y work, and what does it mean?
60
votes
17
answers
1.4K
views
How can I list the tables in a SQLite database file that was opened with ATTACH?
What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I
52
votes
13
answers
2.5K
views
Can I concatenate multiple MySQL rows into one field?
Using MySQL, I can do something like: SELECT hobbies FROM peoples_hobbies WHERE person_id = 5; My Output:
59
votes
30
answers
2.7K
views
55
votes
24
answers
1.9K
views
How to reset AUTO_INCREMENT in MySQL
How can I reset the AUTO_INCREMENT of a field? I want it to start counting from 1 again.
63
votes
7
answers
2.1K
views
What are the options for storing hierarchical data in a relational database?
Good Overviews Generally speaking, you're making a decision between fast read times (for example, nested
63
votes
16
answers
2.6K
views
How can I do an UPDATE statement with JOIN in SQL Server?
I need to update this table in SQL Server with data from its 'parent' table, see below: Table: sale
63
votes
15
answers
385
views
How can I delete using INNER JOIN with SQL Server?
I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, L
54
votes
22
answers
1.2K
views
What is the difference between UNION and UNION ALL?
What is the difference between UNION and UNION ALL?
52
votes
28
answers
2.1K
views
Insert into ... values ( SELECT ... FROM ... )
I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for
55
votes
18
answers
1.4K
views
Select first row in each GROUP BY group?
As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Spec
57
votes
30
answers
1.9K
views
How do I perform an IF...THEN in an SQL SELECT?
How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR
49
votes
30
answers
1.3K
views
How to query MongoDB with "like"
I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' Ho
62
votes
30
answers
1.3K
views
Insert results of a stored procedure into a temporary table
How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp
