2020欧洲杯手机版注册

A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
2 views

Best way to store and handle State Transition data in MySQL?

I've a following States that a Machine can Run into.Power Off Running Stopped Waiting for Resource Ready to Run AlarmOutput is BlockedAnd I'm getting data only when a transition happens. The ...
0
votes
0answers
7 views

Group by in codeiniter return zero in count if there is no row match

$this->db->select('COUNT(status) as status_count, status'); $this->db->where('u_id', $u_id); $this->db->where_in('status', ['2', '3']); $this->db->group_by('status')...
0
votes
1answer
22 views

Mysql join two tables multiple times

I am trying to get two user_name and company name from the same two tables one is gamer_user where u.id = gamer_rec t2.user_idwhere gamer_user has user_name, and gamer_rec has company name...
0
votes
0answers
6 views

How to display multiple node for xmltype in oracle

I have a column b_xml in table T_XML,T_XMLa_var b_xmlA1 <amt1>1</amt1><amt2>1.11</amt2><bmt>1.111</bmt>.....A2 <amt1>2</amt1>&...
0
votes
1answer
22 views

Oracle - How Can I select every Friday for the last six months?

I am working on the currency table. I need to get every Friday for the last six months. My query selects every day between two dates. Here my querySELECT valid_from, currency_code, ...
0
votes
0answers
21 views

Looping over year and month combinations in a SELECT and UNPIVOT query

I have made the following monstrosity of a query which is working correctly (My actual query repeats the same for 2017 and 2018, but the amount of chars in the query is too large for a Stack Overflow ...
0
votes
0answers
11 views

Data is not mapping correctly in CSV file in pyspark?

I am running SQL query on the top of view. I am trying to save query output into csv file using pyspark.While validating the file, i am getting some of records are not in their respective columns. ...
0
votes
0answers
40 views

SQL for summarizing data of the table

Consider the following 3 tables:Transaction Table+---------+--------------+---------------+---------+----------------+------------+------------+| Tran_id | Tran_seq_nbr | Tran_sold_amt | Card_no |...
0
votes
0answers
9 views

Import Julia Dataframe into SQL Server

I've been experimenting with Julia's ODBC.jl and wanted to see if anyone has a good example of taking a DataFrame and loading into SQL Server.Unfortunately the examples (including ODBC.load!()), I've ...
1
vote
3answers
24 views

How to MYSQL get data group by every hour in 24 hours even data if not present , IF 0 will select NULL

For Example DATA and Query Avail on This LINK SQL FIDDLE http://sqlfiddle.com/#!9/13aec/23
-4
votes
1answer
30 views

Query for students passed or not passed in specific Subjects

I have a Table with Column Headings:ID Student_Name Roll_Number Subject1MarksObtained Subject1TotalMarks Subject2MarksObtained Subject2TotalMarks Subject3MarksObtained Subject3TotalMarks ...
0
votes
1answer
14 views

How to the add balance in the next field amount, per Vendorname , per month/year

Good day guys . In my query I want to add the current balance (from previous payable )to the next field amount and subtract it to the payment made (paid field)sample codes select a.vendorname ,...
0
votes
1answer
13 views

How to Create a list of value with data base store image in oracle apex

I have a column of product_id in my form view and I show product image in the list of the value of "product_id" column my code is below but not working.select '<img src="'||apex_util....
0
votes
0answers
16 views

Using SQL Server Always Encrypted feature in stored procedure

I am using SQL Server Always Encrypted feature of Azure SQL with .NET code. While it works like charm inside Entity Framework where the data can be decrypted, not sure how do I use it in stored ...
1
vote
2answers
42 views

Find records if there are other values in other rows

I store translations in a table. I would like to find out every record for which I have a translation. The records differ only in their language code column. The other primary keys are all the same. I ...

15 30 50 per page