Recent questions tagged SQL

0 votes

593 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

818 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

585 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

534 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

642 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

779 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

515 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

404 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

516 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

472 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

500 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

569 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

494 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

447 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

674 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

457 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

749 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

673 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

422 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

363 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

435 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

571 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

743 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

507 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

444 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

427 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

573 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

666 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