Tag: sql

4144 What is the difference between "INNER JOIN" and "OUTER JOIN"? 2008-09-01T22:36:06.940

3169 How do I UPDATE from a SELECT in SQL Server? 2010-02-25T14:36:53.113

2780 How can I prevent SQL injection in PHP? 2008-09-12T23:55:00.900

2388 Add a column with a default value to an existing table in SQL Server 2008-09-18T12:30:04.630

2018 How does database indexing work? 2008-08-04T10:07:12.673

1577 How to concatenate text from multiple rows into a single text string in SQL server? 2008-10-11T23:49:59.470

1492 How to return only the Date from a SQL Server DateTime datatype 2008-09-22T03:31:33.277

1430 How to import an SQL file using the command line in MySQL? 2013-07-16T00:43:48.420

1426 Finding duplicate values in a SQL table 2010-04-07T18:17:29.067

1419 Inserting multiple rows in a single SQL query? 2009-01-17T05:55:54.150

1383 Insert results of a stored procedure into a temporary table 2009-03-17T10:45:26.080

1308 What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? 2011-04-18T17:15:24.680

1285 How do I perform an IF...THEN in an SQL SELECT? 2008-09-15T14:34:09.337

1234 Table Naming Dilemma: Singular vs. Plural Names 2008-12-03T18:09:30.710

1168 What is the difference between UNION and UNION ALL? 2008-09-08T15:19:33.263

1166 Insert into ... values ( SELECT ... FROM ... ) 2008-08-25T12:45:56.930

1113 What are the options for storing hierarchical data in a relational database? 2010-10-29T00:23:33.310

1087 How can I do an UPDATE statement with JOIN in SQL? 2009-08-18T11:40:07.273

1065 How to list the tables in a SQLite database file that was opened with ATTACH? 2008-09-17T12:59:53.633

1034 How to reset AUTO_INCREMENT in MySQL? 2012-01-19T08:37:49.687

1014 Can I concatenate multiple MySQL rows into one field? 2008-11-10T02:34:26.463

974 Get list of all tables in Oracle? 2008-10-15T17:54:49.387

972 Select first row in each GROUP BY group? 2010-09-27T01:23:22.873

966 Parameterize an SQL IN clause 2008-12-03T16:16:43.187

950 How to Delete using INNER JOIN with SQL Server? 2013-05-10T11:38:21.043

946 SQL select only rows with max value on a column 2011-10-12T19:42:07.780

928 Best way to get identity of inserted row? 2008-09-03T21:32:02.587

923 Find all tables containing column with specified name - MS SQL Server 2011-01-31T10:12:26.260

852 How do I limit the number of rows returned by an Oracle query after ordering? 2009-01-22T19:48:43.930

821 Difference between JOIN and INNER JOIN 2009-02-19T14:47:29.977

812 Using group by on multiple columns 2010-03-10T23:11:23.113

795 When should I use Cross Apply over Inner Join? 2009-07-16T17:42:21.513

791 INNER JOIN ON vs WHERE clause 2009-06-19T16:16:24.347

782 SQL update from one Table to another based on a ID match 2008-10-22T07:14:03.313

730 How do I escape a single quote in SQL Server? 2009-10-19T01:18:22.493

728 Retrieving the last record in each group - MySQL 2009-08-21T17:04:04.147

726 Save PL/pgSQL output from PostgreSQL to a CSV file 2009-10-04T22:58:51.100

716 Insert into a MySQL table or update if exists 2010-11-17T14:08:52.573

713 Should I use != or <> for not equal in T-SQL? 2009-04-06T20:56:15.100

704 Function vs. Stored Procedure in SQL Server 2009-07-24T19:40:06.827

701 How to 'insert if not exists' in MySQL? 2009-09-01T08:56:41.863

667 How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL? 2009-03-04T20:14:26.573

667 Join vs. sub-query 2010-04-05T06:22:22.540

647 DateTime2 vs DateTime in SQL Server 2009-08-26T11:45:10.697

639 Count(*) vs Count(1) - SQL Server 2009-08-03T10:15:10.700

628 Search text in stored procedure in SQL Server 2013-02-05T09:30:39.060

618 SQL Server: How to Join to first row 2010-01-11T16:44:37.123

613 'IF' in 'SELECT' statement - choose output value based on column values 2011-05-10T13:53:31.433

604 How can I list all foreign keys referencing a given table in SQL Server? 2009-01-27T12:17:59.193

576 How to drop a table if it exists in SQL Server? 2011-10-25T09:05:46.817

567 Fastest Way of Inserting in Entity Framework 2011-05-09T17:14:00.243

559 postgres: upgrade a user to be a superuser? 2012-05-25T15:43:18.613

555 SQL exclude a column using SELECT * [except columnA] FROM tableA? 2009-04-08T09:15:28.297

549 MySQL Query GROUP BY day / month / year 2009-02-03T20:29:19.177

549 SQL update query using joins 2009-06-11T18:49:33.633

544 Insert, on duplicate update in PostgreSQL? 2009-07-10T11:38:49.187

543 How do I see what character set a MySQL database / table / column is? 2009-06-26T15:22:20.257

541 How can I get column names from a table in SQL Server? 2009-06-28T14:05:50.193

533 Reset identity seed after deleting records in SQL Server 2014-02-17T08:51:48.637

530 SQL join: where clause vs. on clause 2008-12-09T20:14:52.187

526 When to use single quotes, double quotes, and back ticks in MySQL 2012-07-04T01:53:36.917

525 SQL injection that gets around mysql_real_escape_string() 2011-04-21T07:56:11.147

517 SQL multiple column ordering 2010-01-12T18:02:09.567

516 Fetch the row which has the Max value for a column 2008-09-23T14:34:13.877

512 What is the difference between Left, Right, Outer and Inner Joins? 2009-01-15T19:07:31.377

511 Rename column SQL Server 2008 2013-04-30T09:34:48.440

510 How to do a FULL OUTER JOIN in MySQL? 2011-01-25T17:34:18.777

508 Solutions for INSERT OR UPDATE on SQL Server 2008-09-20T15:00:47.833

502 SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported 2011-03-30T14:45:11.100

501 Is it possible to insert multiple rows at a time in an SQLite database? 2009-10-22T20:04:42.983

489 How to temporarily disable a foreign key constraint in MySQL? 2013-03-19T14:03:58.643

478 What is the most efficient/elegant way to parse a flat table into a tree? 2008-10-10T16:47:43.223

478 Skip certain tables with mysqldump 2009-01-08T17:30:17.323

468 SQLite - UPSERT *not* INSERT or REPLACE 2009-01-07T01:47:23.903

466 MySQL: @variable vs. variable. What's the difference? 2009-06-17T23:04:00.137

462 java.util.Date vs java.sql.Date 2010-02-21T13:16:40.210

459 How do I split a string so I can access item x? 2008-08-05T18:15:47.727

456 Best approach to remove time part of datetime in SQL Server 2009-07-24T12:49:54.420

455 How to request a random row in SQL? 2008-08-21T06:28:49.927

452 NOT IN vs NOT EXISTS 2008-10-06T02:19:05.033

446 How do I restore a dump file from mysqldump? 2008-09-19T21:27:00.673

444 How to insert a line break in a SQL Server VARCHAR/NVARCHAR string 2008-08-27T19:53:01.303

408 MySQL select 10 random rows from 600K rows fast 2010-12-01T21:35:14.593

406 Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? 2010-04-23T11:36:37.853

405 MySql export schema without data 2011-05-30T11:06:54.273

404 Select statement to find duplicates on certain fields 2010-12-13T22:30:06.130

401 Get top 1 row of each group 2011-07-27T08:41:16.790

399 Is there a Max function in SQL Server that takes two values like Math.Max in .NET? 2008-09-23T22:52:03.837

397 What is the syntax for an inner join in LINQ to SQL? 2008-09-01T01:00:24.467

396 SQL query return data from multiple tables 2012-09-18T11:11:39.310

395 How to convert java.util.Date to java.sql.Date? 2009-02-09T21:16:18.010

392 Difference between EXISTS and IN in SQL? 2008-08-24T08:42:23.843

382 Delete all Duplicate Rows except for One in MySQL? 2011-01-13T20:58:38.427

378 What is the best way to paginate results in SQL Server 2008-09-20T20:16:18.633

362 Adding an identity to an existing column 2009-06-26T13:41:21.333

356 When to use "ON UPDATE CASCADE" 2009-09-26T15:41:49.383

353 SQL SELECT WHERE field contains words 2013-01-12T06:19:50.197

352 Exporting data In SQL Server as INSERT INTO 2009-10-04T08:57:36.447

352 Hibernate show real SQL 2010-03-29T09:17:21.660