Questions tagged [sql]
Structured Query Language (SQL) is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used. If your question relates solely to a specific DBMS (uses specific extensions/features), use that DBMS's tag instead. Answers to questions tagged with SQL should use ISO/IEC standard SQL.
573,134
questions
0
votes
0answers
19 views
Java DB Connection using JDBC
I have a question regarding database connection
I am using the Apache Derby database
When I trying to connect to my database using DriverManager I am having an error
private final String DATABASE_URL ...
-1
votes
1answer
32 views
Transpose fixed number of rows in columns
I have a dataset(one column , multiple rows) mentioned below. I want to transpose first 5 rows in columns - 1st row, next 5 rows in 2nd row's column and so on. Can anyone help me with SQL query to ...
0
votes
1answer
13 views
Can't seem to save object into database
This is my ActiveRecord:
class CreateTasks < ActiveRecord::Migration[6.1]
def change
create_table :tasks do |t|
t.string :title
t.text :body
t.datetime :due
t.integer :...
1
vote
2answers
31 views
Collect this month data from SQL using PHP [duplicate]
How can I get data from SQL using PHP of this month (not last 30 days).
If this is January 10, I wan to collect data from January 1 to January 10.
I tried the following code, but it seems to be taking ...
2
votes
0answers
30 views
Can someone explain this SQL query to me? I am not understanding what the buckets are doing or what even is a bucket or bitmask?
Basically the task is to query data to isolate which users have a certain scope of permissions for a project.
select ssm.user_id,s.scope
from user_available_scope_sets uass
join ...
0
votes
1answer
35 views
Current Month, Previous Month, Next Month
This is my query
select *
from RDR1 A
where Year(A.shipdate) = '2021'
and (
Month(A.shipdate) = Month(CURRENT_TIMESTAMP) - 1
or Month(A.shipdate) = Month(CURRENT_TIMESTAMP) + 1
or Month(...
0
votes
1answer
16 views
Convert row to columns in the same table and delete the row from the table
how to select rows from a table by converting matching rows to columns within the same table and delete the row from the table. There are 4 Account number (100,200,111,222) where account number 100 is ...
-1
votes
0answers
20 views
Connect HTTP response to SQL database [closed]
I need to use SQL and Asp.net to make a system that sends the HTTP response / Request response to a site, shows the data retrieved from the SQL server and then, shows what they have received after ...
-1
votes
2answers
27 views
How to sum columns in sql
I know it may be basic, but i'm noob to SQL.
So, i have this query:
select nome_equipa,
sum(case when (resultado_visitado = resultado_visitante) and jogo.equipa_id_equipa = id_equipa or (...
-1
votes
3answers
27 views
Pivot SQL Server results by year
I am at a loss on how to return pivoted results. Any help is greatly appreciated. My data look like this:
Notice SystemCategoryID and DataQualityCategoryID 3 has a record for 2019 and another for ...
0
votes
2answers
28 views
Vector arithmetic for arrays in postgres
It seems postgres supports an array-append natively with an operator:
|| array-to-array concatenation ARRAY[1,2,3] || ARRAY[4,5,6] {1,2,3,4,5,6}
Source: https://www.postgresql.org/docs/current/...
-1
votes
1answer
41 views
Create a new row every day for counting page views
The basic idea is that I'm trying to make a new row everyday for my page views so that I can echo my daily views.
In my database I have three columns: pageid, pagehits and pagedate (the pagedate table ...
0
votes
1answer
22 views
code execute but not inserting data (php)
hi friends from all over the worlds, i went trough many solution in stack but halas i'm still failing at inserting my data.
my php version is 5.5.12
and here is the code of the insert:
$query = $db-...
-1
votes
1answer
26 views
How does BigQuery manage a struct field in a SELECT
The following queries a struct from a public data source:
SELECT year FROM `bigquery-public-data.words.eng_gb_1gram` LIMIT 1000
Its schema is:
And the resultset is:
It seems BigQuery automatically ...
3
votes
1answer
49 views
Why does this index make SELECT GROUP BY queries slower?
Let's say we have a table of 100k transactions (each row is a purchase of product by customer at timestamp dt).
I have noticed that the query
SELECT product, COUNT(customer) FROM transactions GROUP BY ...
欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看