Recent questions tagged SQL

0 votes

370 views

1 answer

sql server - How to get last day of last week in sql?

How to get last date of the lastweek in sql? I mean last sunday date using query? See Question&Answers more detail:os...

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

0 votes

384 views

1 answer

sql - Oracle : select maximum value from different columns of the same row

The whole question is pretty much in the title. For each row of the table I'd like to select the maximum ... query must be compatible oracle 8i. See Question&Answers more detail:os...

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

0 votes

451 views

1 answer

sql - How to do a case sensitive GROUP BY?

If I execute the code below: with temp as ( select 'Test' as name UNION ALL select 'TEST' UNION ALL select 'test ... 1 TEST 1 test 1 tester 2 See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

sql - MySQL - SELECT * INTO OUTFILE LOCAL ?

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to ... of handling this problem? See Question&Answers more detail:os...

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

0 votes

433 views

1 answer

sql - mysql GROUP_CONCAT duplicates

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

0 votes

537 views

1 answer

sql - Select without a FROM clause in Oracle

in SQL Server is possible to execute a SELECT, without reference to a table; something like: Select 1.2 +3, ... practice to use the dual table? See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql - Redundant data in update statements

Hibernate generates UPDATE statements, which include all columns, regardless of whether I'm changing the value in ... version are identical! See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql server - What are the advantages of VistaDB

I have seen the references to VistaDB over the years and with tools like SQLite, Firebird, MS SQL et. al. ... such as triggers. Firebird+MSSQL See Question&Answers more detail:os...

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

0 votes

247 views

1 answer

sql - Match only entire words with LIKE?

So 'awesome document' LIKE '%doc%' is true, because doc is a sub-string. But, I want it to be false ... to use something that isn't available. See Question&Answers more detail:os...

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

0 votes

346 views

1 answer

sql - SELECT query with CASE condition and SUM()

I'm currently using these sql statements. My table has the field CPaymentType which contains "Cash" or "Check". I ... () and CStatus='Active'; See Question&Answers more detail:os...

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

0 votes

464 views

1 answer

sql - how to remove time from datetime

The field DATE in the database has the following format: 2012-11-12 00:00:00 I would like to remove the time ... the date like this: 11/12/2012 See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql - What is the best way to generate ranks in MYSQL?

What's the best way to get the rank of the rows in addition to the row data in MYSQL? For instance, say I ... well in the rowdata I get back? See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql server - SQL Fuzzy Matching

Hope i am not repeating this question. I did some search here and google before posting here. I am running ... like my suggestions? Thanks. See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - Oracle IN vs Exists difference?

I am confused with oracle IN and EXISTS. I have below requirement. I need to get all the employees whose ... has any such limitation? Thanks! See Question&Answers more detail:os...

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

0 votes

602 views

1 answer

sql server - How to concatenate many rows with same id in sql?

My table contains the details like with two fields: ID DisplayName 1 Editor 1 Reviewer 7 EIC 7 Editor 7 Reviewer 7 ... ? How to write the Query? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

sql - PARTITION BY with and without KEEP in Oracle

I came across two queries which seems to have the same result: applying aggregate function on partition. ... some performance optimization. See Question&Answers more detail:os...

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

0 votes

456 views

1 answer

sql server - T-SQL Skip Take Stored Procedure

I don't seem to be having much luck on this site, still forever the optimist, I will keep trying. I ... procedure. Many Thanks. Many thanks, See Question&Answers more detail:os...

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

0 votes

400 views

1 answer

sql - How to select the first N rows of each group?

I have two SQLite tables like this: AuthorId | AuthorName ---------------------- 1 | Alice 2 | Bob 3 ... or top). The problem is with the two). See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

sql server - How to call Stored Procedure in a View?

How would I call a Stored Procedure that returns data in a View? Is this even possible? See Question&Answers more detail:os...

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

0 votes

417 views

1 answer

sql - Python, SQLAlchemy pass parameters in connection.execute

I am using SQLAlchemy connection.execute(sql) to transform select results to array of maps. Have ... __sql_to_data(sql_get_profile,user_id) See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Postgres Error: More than one row returned by a subquery used as an expression

I have two separate databases. I am trying to update a column in one database to the values of a column ... used as an expression Any ideas? See Question&Answers more detail:os...

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

0 votes

485 views

1 answer

sql - Insert/ Update random date in MySQL

How would I update a column with a random date in the past 2 weeks using MySQL? For example (code doesn't actually ... sysdate() - rand(1, 14); See Question&Answers more detail:os...

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

0 votes

326 views

1 answer

sql - Using IF ELSE statement based on Count to execute different Insert statements

While I am searching through my database, I run an INSERT statement if I find that a particular item does not ... GROUP BY [Some Column] ) See Question&Answers more detail:os...

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

0 votes

417 views

1 answer

sql - Timestamp Difference In Hours for PostgreSQL

Is there a TIMESTAMPDIFF() equivalent for PostgreSQL? I know I can subtract two timestamps to get a postgresql ... "age" FROM "links_link" See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - MySQL: Typecasting NULL to 0

Let us suppose the following table (e.g. a result of several inner join statements): id | column_1 | column_2 --- ... , but a NULL stays a NULL. See Question&Answers more detail:os...

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

0 votes

284 views

1 answer

sql - Getting row number for query

I have a query which will return one row. Is there any way I can find the row index of the row I'm ... = Convert.ToInt32(cmd.ExecuteScalar()); See Question&Answers more detail:os...

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

0 votes

384 views

1 answer

sql server - How to find the boundaries of groups of contiguous sequential numbers?

I have a table with the following definition CREATE TABLE mytable ( id INT IDENTITY(1, 1) PRIMARY KEY, ... Number 1014 1015 Number 1017 1017 See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

sql server - How to avoid SSIS FTP task from failing when there are no files to download?

I'm using SQL Server 2005, and creating ftp tasks within SSIS. Sometimes there will be files to ftp over, ... in a more secure location.) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags