Recent questions tagged SQL

0 votes

738 views

1 answer

sql - Merge duplicate temporal records in database

I have a temporal database table where some of the data is duplicated. EmployeeId StartDate EndDate Column1 Column2 ... can this be achieved? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

854 views

1 answer

sql server - Stored procedure - truncate table

I've created a stored procedure to add data to a table. In mock fashion the steps are: truncate original table ... when the data is deleted? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

800 views

1 answer

sql - MySQL to fill in missing dates when using GROUP BY DATE(table.timestamp) without joining on temporary table

after reading through a couple similar Qs/As I haven't quite found the solution I'm looking for. The table data I ... :10 [count] => 8 Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

704 views

1 answer

sql - MySQL select specific row values as column names

Here is my basic participants table (displayed as associative array): [id] => 1 [campaign_id] => 41 [ ... situation. Thanks for any help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

905 views

1 answer

sql server 2008 - Three column SQL PIVOT

How do I do a sql pivot of data that looks like this, USING the SQL PIVOT command ? id | field | value -- ... 2 2010 July 31 3 2009 January NULL See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

754 views

1 answer

sql server - Subtotals and SQL

I have a SQL table of sales data (like the one below), how can I generate a result set that inlines the ... were actually pretty helpful to me. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

880 views

1 answer

sql - How to generate all n-grams in Hive

I'd like to create a list of n-grams using HiveQL. My idea was to use a regex with a lookahead and the ... instead. Thanks a lot in advance! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

788 views

1 answer

sql - Rails/ActiveRecord sort by particular value

Is there any convenient way in Rails 3.2 to order an ActiveRecord relation by moving records with a particular ... the front of the relation. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

sql - Cascade copy a row with all child rows and their child rows, etc

I'm attempting to track items in commercial building construction (specifically concrete cladding). A project can have ... how to fix it. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

717 views

1 answer

sql server - To get date from datetime in sql

I have datecreated field in a table. It contains value as "2009-12-30 11:47:20:297" I have a query ... executing above query. Can anybody help? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

713 views

1 answer

sql - Multiple column values in a single row

I have table like this ID Status 1 5 1 6 1 7 2 5 2 6 2 7 I need the result like below ID col1 col2 col3 1 5 6 7 2 5 6 7 Please help me See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

717 views

1 answer

sql - Hive - Is there a way to further optimize a HiveQL query?

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

645 views

1 answer

sql - Converting a number into a word in Mysql

I am getting a value from database and I want this value to be converted into a word in Mysql. can ... displayed as hundred and twenty three. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

678 views

1 answer

sql server - SQL Threadsafe UPDATE TOP 1 for FIFO Queue

I have a table of invoices being prepared, and then ready for printing. [STATUS] column is Draft, Print, Printing ... ) Thanks for all the help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

sql server - Entity Framework Cascade Delete

I have Table A and Table B on SQL Server. Table B has an foreign key to Table A. I want to cascade ... SQL Server and on Entity Data Model? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

763 views

1 answer

sql - Time based priority in Active Record Query

I have a table which has job listings, which when displayed are normally ordered by the created_at field ... jobs, ordered by created_at. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

591 views

1 answer

sql - Query a table and a column name stored in a table

I come here because of a problem that I am not experienced enough to solve, in an Oracle Database. Let me ... find how to format it better) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

635 views

1 answer

sql - Can this MySQL db be improved or is it good as it is?

In a classifieds website, you have several categories (cars, mc, houses etc). For every category chosen, a hidden ... and the PK here? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

806 views

1 answer

sql - MySQL to update an XML attribute

In data load, it seems some XML attributes mapped incorrectly and I'm now trying to correct this, but ... it's associated subfield attributes) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

sql server - How to pivot without knowing fixed columns in T-SQL

I have a table called balance which I wish to pivot, however it is quite difficult since the column names would be ... ) ) v (Customer, Balance) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

925 views

1 answer

sql - using comma separated values inside IN clause for NUMBER column

I have 2 procedures inside a package. I am calling one procedure to get a comma separated list of user ids. I ... error. Can someone help here. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

852 views

1 answer

sql - Second Highest Salary

Write a SQL query to get the second highest salary from the Employee table. | Id | Salary | | 1 | 100 | ... | and not |SecondHighestSalary| | | See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

sql server 2008 - How to do Paging for jqGrid in Stored Procedure?

I'm not good at sql, but I have to do paging for jqGrid in my stored procedure which has many records. My asp ... , how to do paging for jqgrid? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

725 views

1 answer

sql server - "Simple" SQL Query

Each of my clients can have many todo items and every todo item has a due date. What would be ... timestamp_due, timestamp_completed) Thank you. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

807 views

1 answer

sql - count number of rows in table using php

I just want to count the number of rows in a table that already created in a database using php. I used mysqli( ... in the table as the output. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

606 views

1 answer

sql server - What is the best way to refresh a rollup table under load?

I created a table in my SQL Server 2005 database and populated it with summary and calculated values. The ... and other trouble lurking? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

639 views

1 answer

sql server - How do I pass a variable that contains a list to a dynamic SQL query?

I have a function that converts a sting list of numbers into a table of integers: USE [IFRS_Temp] GO /** ... because my query is dynamic. Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

708 views

1 answer

sql - Random sorting query Access

I'm using this simple query to use a random sorting on a ms-access database: SELECT pk FROM TABLE ORDER BY ... .eof 'do stuff Rs.Movenext loop See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags