Recent questions tagged SQL

0 votes

217 views

1 answer

sql - Combining rows of queried results by unique identifier?

I have a query that searches through several tables and returns one row for every value in one specific column of ... Can anyone help with this? See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql - Checking if a string is found in one of multiple columns in mySQL

I need to check if a string is found in one or more columns. Basically, I have a program which lets ... where returned. Any suggesstions please? See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql - How to select more than 1 record per day?

This is a postgresql problem. PostgreSQL 8.3.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 ... date_time <= '20121130 23:59:59' See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql server - SSIS ragged file not recognized CRLF

In SSIS, I try to load data from a flat file. The flat file have fixed width columns, but some column are not ... in b column all the 3rd row. See Question&Answers more detail:os...

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

0 votes

252 views

1 answer

sql - Full Join on MS Access

so I'm trying to do a full join on MS Access 2003 but just found out it did not support it. So I tried ... its just not taking my right join... See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

sql - CHECK constraint on date of birth?

I am creating my employee table in Oracle and for emp_date I would like to make it so the date of birth is not ... '1950-01-01' AND sysdate)) See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql - Searching a column containing CSV data in a MySQL table for existence of input values

I have a table say, ITEM, in MySQL that stores data as follows: ID FEATURES -------------------- ... 3. Any help is deeply appreciated. Thanks See Question&Answers more detail:os...

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

0 votes

425 views

1 answer

sql - PHP is truncating MSSQL Blob data (4096b), even after setting INI values. Am I missing one?

I am writing a PHP script that goes through a table and extracts the varbinary(max) blob data from each record into ... .pdf Done (4096) etc.. See Question&Answers more detail:os...

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

0 votes

267 views

1 answer

sql server - How can I assign a name to the SUM column?

how can I assign a column name to the SUM column ? i.e. select OwnerUserId, SUM(PostScore) INTO Experts from . ... results of SUM has not name. See Question&Answers more detail:os...

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

0 votes

202 views

1 answer

sql server - SQL Service Broker -- one central SQL and more satellite SQL

The system consists of one central SQL server and two or more satellite servers. The satellite servers collect the ... Can you comment on that? See Question&Answers more detail:os...

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

0 votes

298 views

1 answer

sql server - Unordered results in SQL

I have read it over and over again that SQL, at its heart, is an unordered model. That means executing ... which there cannot be any guarantee. See Question&Answers more detail:os...

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

0 votes

283 views

1 answer

sql - Selecting distinct values for multiple columns

I have a table where many pieces of data match to one in another column, similar to a tree, and then data ... there would be a simpler way See Question&Answers more detail:os...

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

0 votes

295 views

1 answer

sql server - jdbc sql error: statement did not return a result set

I have two stored procedures as follows: create stored procedure p1 as select * from table1 where datediff(day, ... there a way around this? See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - MS Access Select top n query grouped by multiple fields

This is part 2 of a problem that was already answered by peterm on this board. Thanks again peterm! So I ... another table. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql server 2005 - MSSQL Row_Number() over(order by) in MySql

i need to make a group by clause with the following query: SELECT NAME, SUM(donationvalue) FROM ... NAME is this possible? See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql - Window functions: PARTITION BY one column after ORDER BY another

Disclaimer: The shown problem is much more general than I expected first. The example below is taken from a ... way to achieve this result. See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

sql server - Executing SSIS Package with SQL Authentication

I have a SSIS package that talks to a remote server over HTTP. I execute the SSIS package using a stored ... command line call to package)? See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql server - How Do You Tell What Next Identity Column Will Be?

Is there a tsql query to tell what SQL server identity column value it expects to use for the next row ... your next identity column number. See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

sql - PIVOT rows to columns with more than 1 value returned

I am currently working on a system that has 2 tables set up like so: Table_1 ------- ID Table2ID ... receive multiple results for each column? See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

sql - Strip out non-numeric characters in SELECT

In an MS Access 2007 project report, I have the following (redacted) query: SELECT SomeCol FROM SomeTable The ... a CAST or CONVERT function? See Question&Answers more detail:os...

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

0 votes

394 views

1 answer

sql - how to create calculated field in mysql?

i have a table like below: create table info (username varchar(30),otherinfo varchar(100)); now i want to alter ... do so? Thanks for your help See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql - how to select columns as rows?

So, I've been searching around and I've found things similar to my problem, but I need more help to get ... the query. Any help is appreciated! See Question&Answers more detail:os...

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

0 votes

243 views

1 answer

sql - Oracle get foreign keys

I'd like to get all foreign keys in a schema, like this. Let's say I have tables users(id, ... constraint_name WHERE C.R_OWNER = 'TRWBI' See Question&Answers more detail:os...

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

0 votes

286 views

1 answer

sql - Is it possible to use LIKE and IN for a WHERE statment?

I have a list of place names and would like to match them to records in a sql database the problem is the ... IN LIKE('Ballymena%','Banger%') See Question&Answers more detail:os...

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

0 votes

300 views

1 answer

sql - return count 0 with mysql group by

database table like this ============================ = suburb_id | value = 1 | 2 = 1 | 3 = 2 | 4 = 3 | 5 ... 2 | 1 = 1 | 2 = 1 | 3 = 0 | 4 See Question&Answers more detail:os...

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

0 votes

284 views

1 answer

sql - There is already an object named '#columntable' in the database

I am trying the following query if exists (select 1 from emp where eid = 6) begin if object_id('tempdb.. ... do not write the else part. See Question&Answers more detail:os...

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

0 votes

447 views

1 answer

sql server - ALTER TABLE my_table ADD @column INT

If i want to use a variable as name of the new column, is this posible in MS SQL? Example that dont work: ALTER ... ADD ' + @column + ' INT') See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql - Select query with date condition

I would like to retrieve the records in certain dates after d/mm/yyyy, or after d/mm/yyyy and before d/mm/yyyy, ... 1/09/2010 It doesn't work. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags