sql Archives - Page 35 of 45

How to insert a value that contains an apostrophe (single quote)?

What is the correct SQL syntax to insert a value with an apostrophe in it? Insert into Person (First, Last) Values 'Joe', 'O'Brien' ...

May 7, 2022
0 Comments

How to use GROUP BY to concatenate strings in MySQL?

Basically the question is how to get from this: foo_id foo_name 1 A 1 B 2 C to this: foo_id foo_name 1 A ...

May 7, 2022
0 Comments

Best way to select random rows PostgreSQL

I want a random selection of rows in PostgreSQL, I tried this: select * from table where random() < 0.01; But some other ...

May 7, 2022
0 Comments

What’s the difference between VARCHAR and CHAR?

What’s the difference between VARCHAR and CHAR in MySQL? I am trying to store MD5 hashes. 17 Answers 17

May 7, 2022
0 Comments

Select statement to find duplicates on certain fields

Can you help me with SQL statements to find duplicates on multiple fields? For example, in pseudo code: select count(field1,field2,field3) from table where ...

May 7, 2022
0 Comments

How to avoid the “divide by zero” error in SQL?

I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way ...

May 7, 2022
0 Comments

How to select rows with no matching entry in another table?

I’m doing some maintenance work on a database application and I’ve discovered that, joy of joys, even though values from one table are ...

May 7, 2022
0 Comments

You can’t specify target table for update in FROM clause

I have a simple mysql table: CREATE TABLE IF NOT EXISTS `pers` ( `persID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(35) NOT NULL, `gehalt` ...

May 6, 2022
0 Comments

How do I query for all dates greater than a certain date in SQL Server?

I’m trying: SELECT * FROM dbo.March2010 A WHERE A.Date >= 2010-04-01; A.Date looks like: 2010-03-04 00:00:00.000 However, this is not working. Can anyone ...

May 6, 2022
0 Comments