Recent questions tagged SQL

0 votes

403 views

1 answer

sql - MySQL request for combining and searching in 2 tables

I have 2 tables. One of my tables with users is: id name longitude latitutde ----- ----- ----------- ... to return 20 Ids of the nearby people ? See Question&Answers more detail:os...

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

0 votes

519 views

1 answer

sql - How to use ADO Query Parameters to specify table and field names?

I'm executing an UPDATE statement in a TADOQuery and I'm using parameters for a few things. Initially, this was ... table and field to update? See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql - MySQL :: Select from comma separated string

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

0 votes

558 views

1 answer

sql - Concatenate multiple rows

I'm using Microsoft SQL Server 2005. I think I need a sub-query. I'm looking for one (1) row per ... <option value="103">Delete</option> See Question&Answers more detail:os...

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

0 votes

510 views

1 answer

sql - Want a stored procedure for comma seperated string which is of a column (has 20000 rows ) in a table

I have a table with 20000 rows, and a column that has comma-separated strings in it. I want split each of the ... the given column - any help? See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

sql - Oracle ORA-00979 - "not a GROUP BY expression"

Can anybody please help me with this particular query? I'm having ORA-00979 when trying to run this: select ... tdata.tariff group by t0.title See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

sql - Find out the nth-highest salary from table

name salary ----- ----- mohan 500 ram 1000 dinesh 5000 hareesh 6000 mallu 7500 manju 7500 praveen ... the aforementioned table using Oracle? See Question&Answers more detail:os...

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

0 votes

313 views

1 answer

sql - Query Data from XML

I'm trying to fetch specific data from an XML Document using sql statement. This document is as follows: < ... </nsREF:Measure> </Ophthalmology> See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - How can I get only one row per record in master table?

it is possible to get only one row per record in a multitable query? I have this three tables: APPLES ID | APPLE --- ... s FARM | YES | NO | YES See Question&Answers more detail:os...

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

0 votes

391 views

1 answer

sql - Running sum in Access query with Group By

I can't get a running sum to work in an Access query. I have a pipesystem, where I'm trying to summarize ... as shown in the table and picture. See Question&Answers more detail:os...

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

0 votes

995 views

1 answer

sql - ORA-00936: missing expression oracle

I have this query SELECT DAL_ROWNOTABLE.DAL_ID FROM ( SELECT ticket.id AS "DAL_ID", ROWNUMBER ( Order By ticket ... beginning of first order by: See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql server - better way to generate months/year table

I am starting to use more tsql again. Is there a better way then the one below to generate a table ... , date) option (maxrecursion 0) See Question&Answers more detail:os...

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

0 votes

451 views

1 answer

sql - Oracle Rows to Column Transformation

I have a table select * from table values returning are login id | status_name | count =========================== ... 0 user1 | 0 | 5 | 0 | 10 See Question&Answers more detail:os...

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

0 votes

657 views

1 answer

sql - Oracle Shutdown error ORA-01033

I had installed Oracle 11g on windows 07,everything was working fine.But today it is giving me an error saaying ... .DBF' Thanks in advance!! See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql - Ordered count of consecutive repeats / duplicates

I highly doubt I'm doing this in the most efficient manner, which is why I tagged plpgsql on here. I need to run ... that's a better way to go? See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql - Passing multiple values in single parameter

Let's say I have this function: CREATE OR REPLACE FUNCTION test_function(character varaying) RETURNS integer AS ... clause can recognized it? See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql - Combining 3 SELECT statements to output 1 table

I have three queries with results. Query 1: SELECT DISTINCT employeeid, work.clientid, ROUND ((CAST (AVG( ... . Anyone have a clue? See Question&Answers more detail:os...

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

0 votes

554 views

1 answer

sql - Transposing SQLite rows and columns with average per hour

I have a table in SQLite called param_vals_breaches that looks like the following: id param queue date_time param_val ... go about it. Thanks! See Question&Answers more detail:os...

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

0 votes

288 views

1 answer

sql server - Using Dates from Cell or named Range in Sql Query

I have created a sheet to extract data from a Microsoft SQL database to produce a customer report between 2 date ... I hope this makes sense. See Question&Answers more detail:os...

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

0 votes

809 views

1 answer

sql server - Syntax for a parameter query in Python (pyodbc)

I am trying to write results of some processing into SQL Server table. My results are store in a list of ... knows why my execution fails ? See Question&Answers more detail:os...

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

0 votes

471 views

1 answer

sql - Add *.mdf file to C# Project

I'm using Visual Studio 2005. I create a project, not Web Project, just Windows application. I remember that ... mdf file into my project. See Question&Answers more detail:os...

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

0 votes

322 views

1 answer

sql server - how to split and insert CSV data into a new table in single statement?

I have a table named "Documents" containing a column as below: DocumentID I have data in the format - @DocID ... rows using a single query? See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql - Search if number is contained within an expression like: 1-3,5,10-15,20

In an oracle database-table I need to find a result for a given lot-number. The field where lot-numbers are ... FROM products WHERE lot = 2" See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql server - CTE in From clause of SQL Query

I need to use CTE query inside from clause of SQL Query See this example: Drop Table #Temp Drop Table #Temp2 ... may not be the CTE query. See Question&Answers more detail:os...

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

0 votes

354 views

1 answer

sql server - TSQL: Nested split/parse of string into table (multiple concatenated Tag:Value in one string)

I would like a TSQL table-values function that can perform nested parsing and return the result in a two column table. ... Value a|1 b|16 x|99 See Question&Answers more detail:os...

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

0 votes

694 views

1 answer

sql - BigQuery UPDATE nested array field

I need to update nested field in one table, using the value from another table. Using this solution i came up ... prod LIMIT 1) = map.raw_name See Question&Answers more detail:os...

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

0 votes

470 views

1 answer

sql server - Using UDF for default value of a column

I created a UDF that I am using to generate a default value for a column. It works great, but I want ... value. Any help would be appreciated! See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

sql server 2008 - Strange problem with nvarchar(max) fields and Classic ASP

I'm working on a Classic ASP (VBScript) site that's running on a Windows 2008 server with IIS7 and hitting a SQL ... and how to get around it? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags