Alex Rivera | Logout

Questions tagged sql

2403 questions · page 2 of 49

Sort by: Newest Votes Active
34
votes
3
answers

right join even if row on second table does not exist

mysql sql
asked 2013-06-07T15:07:09.703
9
votes
2
answers

PostgreSQL - INNER JOIN two tables with a LIMIT

sql postgresql
asked 2013-06-03T08:41:57.597
10
votes
4
answers

Getting Data from SQL and putting in a list

c# .net sql
asked 2013-05-31T11:54:20.250
8
votes
2
answers

Slow OR statement in postgresql

sql postgresql
asked 2013-05-29T13:42:29.443
45
votes
2
answers

VS2012 Post-Deployment script referring to several other scripts

sql visual-studio-2012 database-project
asked 2013-05-28T08:45:34.520
57
votes
2
answers

SQL recursive query that gets all ancestors of an item

sql sql-server
asked 2013-05-25T11:31:10.463
93
votes
2
answers

Is it necessary to use # for creating temp tables in SQL server?

sql sql-server sql-server-2008 sql-server-2005
asked 2013-05-25T11:25:30.020
15
votes
7
answers

Very slow DELETE query

sql sql-server performance sql-execution-plan table-variable
asked 2013-05-23T12:59:55.473
11
votes
3
answers

MySql. How to use Self Join

mysql sql self-join
asked 2013-05-22T21:32:39.513
237
votes
11
answers

Error on renaming database in SQL Server 2008 R2

sql sql-server sql-server-2008-r2
asked 2013-05-22T06:53:45.953
288
votes
6
answers

How to create a table from select query result in SQL Server 2008

sql sql-server sql-server-2008
asked 2013-05-22T04:57:38.890
9
votes
2
answers

SQL - return deleted rows

sql select sql-delete
asked 2013-05-21T12:11:48.597
14
votes
7
answers

MySql count() to return 0 if no records found

mysql sql
asked 2013-05-19T15:43:37.393
51
votes
13
answers

SQL Differences between stored procedure and triggers

sql stored-procedures triggers
asked 2013-05-18T20:07:05.870
42
votes
3
answers

Update one row in the table, using liquibase

sql database liquibase
asked 2013-05-18T18:33:16.150
15
votes
4
answers

sql rounding up to a multiple of 5?

sql sql-server t-sql
asked 2013-05-16T16:15:46.753
77
votes
6
answers

Counting number of grouped rows in mysql

mysql sql count
asked 2013-05-16T10:06:28.447
27
votes
4
answers

Getting count of records in child table using select statement

sql sql-server sql-server-2008 t-sql sql-server-2008-r2
asked 2013-05-15T08:44:38.510
36
votes
3
answers

Can an INSERT operation result in a deadlock?

sql insert deadlock
asked 2013-05-14T02:42:11.527
16
votes
2
answers

Entity Framework and CROSS/OUTER APPLY

sql sql-server entity-framework cross-apply outer-apply
asked 2013-05-11T19:35:37.797
11
votes
2
answers

Where clause when using XML in SQL

sql sql-server xml sql-server-2012
asked 2013-05-10T14:26:06.750
25
votes
3
answers

How to increase dbms_output buffer?

sql oracle-database plsql oracle10g dbms-output
asked 2013-05-10T06:39:37.057
14
votes
1
answers

OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on '192.168.129.139' (111)") None None

python mysql sql sqlalchemy
asked 2013-05-09T22:26:57.150
20
votes
2
answers

How to limit the maximum display length of a column in PostgreSQL

sql postgresql
asked 2013-05-09T14:40:36.050
10
votes
2
answers

SQL way to get the MD5 or SHA1 of an entire row

sql hash md5
asked 2013-05-09T00:57:44.003
8
votes
5
answers

Combine two queries to check for duplicates in MySQL?

mysql sql
asked 2013-05-08T20:13:20.370
10
votes
2
answers

How to write a query with join, update and order by?

mysql sql join sql-update sql-order-by
asked 2013-05-08T15:27:55.197
29
votes
2
answers

How to get array/bag of elements from Hive group by operator?

sql hadoop hive apache-pig bigdata
asked 2013-05-08T15:03:37.293
24
votes
6
answers

How to make JOIN query use index?

mysql sql join query-optimization
asked 2013-05-05T14:45:19.260
66
votes
6
answers

Does Sql JOIN order affect performance?

sql sql-server
asked 2013-05-03T14:07:03.363
19
votes
3
answers

SQL how to convert row with date range to many rows with each date

sql sql-server-2008-r2
asked 2013-05-03T12:29:17.690
15
votes
4
answers

Check if value is date and convert it

sql sql-server sqldatetime
asked 2013-05-03T07:02:41.663
76
votes
9
answers

Rails includes with conditions

sql ruby-on-rails
asked 2013-05-02T21:52:29.297
43
votes
5
answers

Using group by and having clause

sql
asked 2013-05-01T23:17:41.890
13
votes
3
answers

date_sub ok with mysql, ko with postgresql

sql postgresql
asked 2013-05-01T14:16:09.323
8
votes
2
answers

How can I print SQL query result log with log4j?

sql spring jdbc log4j mybatis
asked 2013-04-26T11:15:32.900
11
votes
2
answers

Get all employee who directly or indirectly reports to an employee, with hierarchy level no

sql sql-server foreign-keys iteration primary-key
asked 2013-04-26T08:56:25.490
70
votes
6
answers

MySQL LEFT JOIN 3 tables

mysql sql join
asked 2013-04-25T18:30:56.777
45
votes
4
answers

Does EF upsert have to be done manually?

c# sql entity-framework
asked 2013-04-24T15:19:45.280
17
votes
6
answers

Table is mutating, trigger/function may not see it (stopping an average grade from dropping below 2.5)

sql oracle-database triggers
asked 2013-04-24T01:51:34.640
26
votes
2
answers

Using Excel VBA to export data to MS Access table

sql excel ms-access vba
asked 2013-04-23T05:47:09.510
13
votes
6
answers

ORA-01031 Insufficient privileges while CREATING a VIEW?

sql oracle-database view oracle11g
asked 2013-04-20T21:36:26.043
21
votes
2
answers

SQL Server : left join results in fewer rows than in left table

sql sql-server left-join
asked 2013-04-20T04:27:15.603
8
votes
2
answers

using if statement how to replace values

sql sql-server-2008 if-statement sql-update case
asked 2013-04-13T05:23:43.730
9
votes
4
answers

Access substitute for EXCEPT clause

sql ms-access
asked 2013-04-12T20:43:09.070
10
votes
4
answers

Determining query's progress (Oracle PL/SQL)

sql database oracle-database plsql monitoring
asked 2013-04-10T23:03:33.103
8
votes
2
answers

SQL Server Create Table with Foreign Key

sql sql-server sql-server-2008
asked 2013-04-10T22:26:13.040
11
votes
4
answers

Inserting into table with a Default column value

sql sql-server
asked 2013-04-09T10:57:36.887
9
votes
3
answers

sql select with does not contain

sql oracle-database
asked 2013-04-09T08:11:50.243
31
votes
2
answers

SQL Update - Multiple Columns

sql t-sql sql-server-2012
asked 2013-04-08T14:16:33.120
← Prev page 2 of 49 Next →