Recent questions tagged SQL

0 votes

536 views

1 answer

sql - Find first non-null values for multiple columns

I'm attempting to get the first non-null value in a set of many columns. I'm aware that I could accomplish ... 4 8 Does anyone know a solution? See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

sql server - Convert exponential to number in sql

I have a large amount of card tokens (16 digits) uploaded from xml file to sql-server. The problem ... AS FLOAT)) FROM MULTICURRENCY_CHECK See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

sql server - UNION versus SELECT DISTINCT and UNION ALL Performance

Is there any difference between these two performance-wise? -- eliminate duplicates using UNION SELECT col1,col2,col3 ... col3 FROM Table8 ) x See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

sql server - Get records 10 min before system datetime in SQL

i need to find the records 10 min before system current datetime. select Id,TimeStamp from ISAlive where ... GETDATE() --SYSDATETIME() See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

sql - mysql group_concat not bringing entire data

I am using the following query and utilizing the group_concat function. However, at times the data in the ... QuarterId=2 group by SiteName See Question&Answers more detail:os...

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

0 votes

727 views

1 answer

sql - Oracle Trigger ORA-04098: trigger is invalid and failed re-validation

I am trying to create a simple trigger in an oracle 10g database. This script to Create the trigger runs clean. ... Thank you in advance! -David See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

sql - Select average from MySQL table with LIMIT

I am trying to get the average of the lowest 5 priced items, grouped by the username attached to them. However, ... ORDER BY price ASC LIMIT 5 See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql server 2008 - How to create Sql Synonym or "Alias" for Database Name?

I'm using ms sql 2008 and trying to create a database name that references another database. For example ' ... any suggestions on a workaround? See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

sql server 2005 - SQL Insert trigger to update INSERTED table values

I want to create an Insert trigger that updates values on all the inserted rows if they're null, the new values ... . How should I do that? See Question&Answers more detail:os...

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

0 votes

434 views

1 answer

sql server - Can SQL Profiler display return result sets alongside the query?

In SQL Profiler 2005, is it possible to capture a result set in a SQL trace, so that I could see ... one way trace? Thanks! George See Question&Answers more detail:os...

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

0 votes

454 views

1 answer

sql - How can I reuse a Common Table Expression

I am using a Common Table Expression for paging: with query as ( Select Row_Number() over (Order By OrderNum ASC) ... a round-trip to the DB? See Question&Answers more detail:os...

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

0 votes

524 views

1 answer

sql - XML query() works, value() requires singleton found xdt:untypedAtomic

I have a typed xml document stored as text. So I use CONVERT the data type to xml by using a Common Table ... once rather than per method call? See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql - R equivalent of SELECT DISTINCT on two or more fields/variables

Say I have a dataframe df with two or more columns, is there an easy way to use unique() or other R ... as.data.frame(ftable(df$var1, df$var2)) See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

sql - usage of select null?

I see that some examples uses select statement with null. When to use: select null from etc. etc.? See Question&Answers more detail:os...

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

0 votes

610 views

1 answer

sql server - Incorrect syntax near 'THROW'

IF @SQL IS NOT NULL BEGIN BEGIN TRY EXEC sp_executesql @SQL PRINT 'SUCCESS: ' + @SQL END TRY BEGIN CATCH SET ... sure what to make of this. See Question&Answers more detail:os...

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

0 votes

421 views

1 answer

sql server - sql statements with equals vs in

Say that someone came up to you and said we're going to cut down the amount of SQL that we write by replacing ... (at least in these parts). See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

sql - Extract day of week from date field in PostgreSQL assuming weeks start on Monday

select extract(dow from datefield) extract a number from 0 to 6, where 0 is Sunday; is there a way to get the ... Monday (so 0 will be Monday)? See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

sql - BigQuery: how to group and count rows within rolling timestamp window?

I have some experience with MongoDB and I'm learning about BigQuery. I'm trying to perform the following ... limit possible answers. Thanks! See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql - Search all databases for value

Consider have a table like named : People | Id | Name | Code | | 1 | John | 857 | | 2 | ... situations like Connection String in nvarchar field. See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql - find start and stop date for contiguous dates in multiple rows

I'm having a bit of trouble displaying correct data from my table. Im not really sure what to search for ... . Islands could be my solloution? See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql - Query Records and Group by a block of time

I have an application that may be run several times a day. Each run results in data that is written to a ... to get a rough grouping. Thanks! See Question&Answers more detail:os...

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

0 votes

523 views

1 answer

sql - Get top 10 products for every category

I have a query which is something like this SELECT t.category, tc.product, tc.sub-product, count(*) as sales FROM ... for 2 days on this :( See Question&Answers more detail:os...

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

0 votes

679 views

1 answer

sql - Generate a random unique ID using PHP

I have a table that is looks like this. This is some of the general information when a user registers on my ... this using PHP, not SQL. See Question&Answers more detail:os...

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

0 votes

454 views

1 answer

sql - how to do lag operation in mysql

Guys I want to use analytical function lag in mysql. In Oracle it is supported but I can't do it in ... Does Mysql support lag function??? See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - How to retrieve same column twice with different conditions in same table?

This is my table: Anganbadi_ID Food Month ------------------------------------------- 1165 ?? ... ?? NULL Please help me as soon as possible.... See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql - MYSQL INSERT or UPDATE IF

Been looking around the web for a while now and don't seem to be able to come across anything similar to what ... and date (if more recent) See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

sql server - How can I call a sqlserver function from VB.net(or C#) ? Is there some syntax like stored procedure?

Public Sub cleanTables(ByVal prOKDel As Short) Dim sqlParams(1) As SqlParameter Dim sqlProcName As String ... sqlProcName, sqlParams) Thanks See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

sql - Disabling MySQL Strict Mode

I am scanning 5000 csv files into a database. Regrettably the files have '', for 0. Thus when ever I run my ... not fix the problem. Thank you! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags