KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
sql
2403 questions · page 2 of 49
Follow Tag
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 →