Recent questions tagged sql

0 votes

268 views

1 answer

sql - Recursive Subquerying with sorting

I looked at Tim Hall's excellent article here, that allows you to work with self-referenced entities and show ... * FROM J1 ORDER BY DISP_SEQ See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - Why postgres is not using the index in my query

I have 2 tables as follow: tb_st: Columns: st_id | integer st | character varying(80) type | integer Indexes ... unique index is not being used? See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

sql - syntax error: unexpected end of file

I have an SQL query that when it is put in to a function it stops working with this syntax error: unexpected end of ... ' AND '$2'; exit; EOF } See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - "Rolling up" groups in Jaspersoft iReport

I have a profit and loss report that currently has three levels of grouping: 1. Pharmacy 2. Customer 3. ... ASC, PACKTYPE ASC, FILL_MO ASC See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

sql - How to skip comma from csv using double quotes

I am getting a string in the below format after reading data from a csv file v_lastline = '29218368,8062115," Benedict ... to do it in PL/SQL? See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - Table as an argument of a PostgreSQL function

I'm trying to pass a table as an argument in a PostgreSQL function, and I can't find the right keyword (what ... adresses what :) ). Thanks. See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql - Extracting several math operations outputs from single select query

I have three tables that I need to merge to analyse: active, students and bills. 'Active' contains ... -fiddle.com/f/NPQR6aBf8H36XvrefJY2J/0 See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - How to extract values from column and update result in another column

i have this table: CREATE TABLE MyTable ( IdDate int, FullDate varchar(255) ); insert into MyTable (IdDate, ... - Monday 10, February 2015 See Question&Answers more detail:os...

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

0 votes

294 views

1 answer

sql - Query for searching the name alphabetically

I have used the LIKE condition, but it required me to enter the full name into the database to find the name. if ... ("EXCEPTION " + e); } See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql server - Find primary key from one table in comma separated list

I've been given the task at work of creating a report based on a very poorly designed table structure. ... PERSONNEL table. Can anyone help? See Question&Answers more detail:os...

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

0 votes

488 views

1 answer

sql server - Is There A Database Engine that Allows for Queriable Field Constraint Specified by RegEx?

I'm looking for a database engine that can handle data constraints specified via RegEx. So in addition to ... constraints get set and queried? See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - error in calling same function twice in php

I have a function named record_list() which helps me echo fetched query from database every time I refresh/visit ... me identifying this error. See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql - Time Attendances query in Microsoft Access

I'm having troubles with writing a query in Microsoft Access. This is how my table looks like and where i ... query work for the problem above. See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

sql - Get value between 2nd and 3rd comma

I am trying to extract the state from an address where everything is in one column, heres an example: 2901 ... case. Any help is appreciated. See Question&Answers more detail:os...

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

0 votes

511 views

1 answer

sql - Failed because incorrect arithabort setting

I created a unique index (case description should be unique if IsDelete != 1) CREATE UNIQUE NONCLUSTERED INDEX ... help is greatly appreciated! See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - How to add sequenced number based on sorted value in query in Access

I have a query which returns some values (att1). I would like also to have next to it the values which would ... the right approach to do this? See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

sql server - Return rows where ID is in semicolon separated string from subquery MSSQL

I'm trying to query my sql database to return all the rows where the ID is contained in a separate tables column. ... ;10;59' to data type int See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql - get the row with the highest value in MySQL

I want to get the highest value but group by another field on the same table ex: seqid + fileid + name 1 | ... * I'll appreciate any help.tnx See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql server - MS Excel - join external (SQL) data with local table (sheet)

I'm trying to get data from both external source and another sheet of my excel file into one table. What I ... after the table is filled in. See Question&Answers more detail:os...

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

0 votes

408 views

1 answer

sql - Oracle outer join syntax

I have a query that looks like this: select * from find fsc, let lf, cust cus, STRIKE ist WHERE fsc ... , using more modern join syntax? See Question&Answers more detail:os...

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

0 votes

333 views

1 answer

sql server - Getting count from sql tables

I have three tables in which two are master tables and other one is map. They are given below. tbl_Category, ... each row. Please help me. See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql - Why partitions elimination does not happen for this query?

I have a hive table which is partitioned by year, month, day and hour. I need to run a query against it ... but this does not solve the issue. See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - How to evaluate expression in select statement in Postgres

Postgres 9.1+ database contains customers and product. In customers table, customer price is described as sql ... ASP.NET MVC4 application. See Question&Answers more detail:os...

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

0 votes

419 views

1 answer

sql server - Setting variables in SQL functions/probs

Assume I have a normal SQL procedure which has a few arguments. During debugging it would be nice if i could assign ... it doesn't like it?? See Question&Answers more detail:os...

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

0 votes

469 views

1 answer

sql server - dynamic alias in T-SQL query

I've got an issue generating an alias for a field in a query which for example gives me the revenue from last ... a lot in advance! greets Niels See Question&Answers more detail:os...

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

0 votes

462 views

1 answer

sql - select rownum from salary where rownum=3;

How to retrieve third row from any table using "rownum" key word ( i am using oracle-10g) See Question&Answers more detail:os...

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

0 votes

317 views

1 answer

I am using the following query in an MS Access database: SELECT SD.RollNo, SD.Name , ED.ExamName, ( SELECT count( ... I stop it from doing so? See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - How to find if a value exists within a VARRAY

I've created a VARRAY within a table (below) I would like to query whether or not a Title has a particular theme, ... ), Theme_Game('FPS')))) / See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags