• <button id="n9woc"><object id="n9woc"></object></button>

    1. <tbody id="n9woc"></tbody>
    2. <button id="n9woc"><object id="n9woc"></object></button>

      <em id="n9woc"></em>

      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.

      Filter by
      Sorted by
      Tagged with
      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 ...

      15 30 50 per page
      1
      2 3 4 5
      38209
      欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看