Recent questions tagged SQL

0 votes

791 views

1 answer

sql - Joining on columns of different type?

If one column is of type int and say has a value 10. The other column is of type varchar and has a ... or maybe I should rethink my schema? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Calculating age from birthday with oracle plsql trigger and insert the age in table

i have a table dates (dob date, age number(4) ); I will insert a date of birth and a trigger will calculate ... EACH ROW BEGIN getage; END; / See Question&Answers more detail:os...

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

0 votes

861 views

1 answer

sql - how to add second in oracle timestamp

How can I add seconds with timestamp value in Oracle. I tried this .... SELECT CURRENT_TIMESTAMP , ... suitable alternative in Oracle. See Question&Answers more detail:os...

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

0 votes

911 views

1 answer

sql - How to get difference from two timestamp in DB2?

i have a requirement in which i have to get time difference of two timestamp in hours and than later find an ... where name='some name'; See Question&Answers more detail:os...

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

0 votes

698 views

1 answer

sql - How to extend the query to add 0 in the cell when no activity is performed

I have the following query, it is working fine to show the cricket time played per day. All I need is to show 0 ... cricket | 2015-06-22 | 10.01 See Question&Answers more detail:os...

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

0 votes

783 views

1 answer

sql server - SQL Count Of Open Orders Each Day Between Two Dates

I've tried searching but it's likely I'm using the wrong keywords as I can't find an answer. I'm trying ... SQL server. Any ideas? Thanks Nick See Question&Answers more detail:os...

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

0 votes

791 views

1 answer

sql server - Query to get multiple row into single row

I have a table in which following information are there: ITEM WH BATCH DOC NO CLD1 FN B1 3 CLD1 FN B1 3 ... am not getting the desired output. See Question&Answers more detail:os...

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

0 votes

786 views

1 answer

sql server 2008 - SSRS: How to add All option to SSRS dropdown filter?

I'm using SQL Server Reporting Services for SQL 2008 R2. My reports are filtered by two drop-down menus that are ... for any help provided. J. See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

sql server - Database Tuning Advisor recommends to create an existing index

When I run SQL Server 2005 Database Tuning Advisor, it gives a recommendation to create an index, but it will ... .avg_user_impact AS INT) DESC; See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Calculate the time difference between two timestamps in mysql

I work on a MySQL database table that has a column containing timestamps (Ex. 2014-09-16 09:08:05) of the ... I've explain myself clear enough. See Question&Answers more detail:os...

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

0 votes

892 views

1 answer

sql server - Get each file size inside a Folder using SQL

We are keeping images in Folder which can have images & sub folder & these sub folders can also have images & ... solution, you can find it here See Question&Answers more detail:os...

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

0 votes

866 views

1 answer

sql - Get count of items and their values in one column

Consider these Tables: Table Items: ItemID ItemName ------------------ 1 N1 2 N2 3 N4 4 N5 and in ... 4 3 How I can do this without Cursors? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Using timestampdiff in a Derby WHERE clause

I would like to simulate the effect of the following type of query (that is in Microsoft SQL Server syntax) in a ... . I hope someone can help. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Return multiple columns and rows from a function PostgreSQL instead of record

I was reading online about function on PostgreSQL and returns results In this links: SQL function return-type: ... from a PostgreSQL function See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - calling a stored proc over a dblink

I am trying to call a stored procedure over a database link. The code looks something like this: declare ... end loop; CLOSE symbol_cursor; See Question&Answers more detail:os...

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

0 votes

810 views

1 answer

sql - specific mysql update based on group by data

This one has me stumpped. I have 2 tables as so: METERS id | startTime READINGS id | meter_id | readingTime What I ... query. How do I do this? See Question&Answers more detail:os...

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

0 votes

936 views

1 answer

sql - Auto Increment varchar in MySQL

Is there a way to set primary key auto increment, type of varchar in mySql? See Question&Answers more detail:os...

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

0 votes

854 views

1 answer

sql server - How do I make a trigger that only affects the row that was updated/inserted?

I have a table with two columns where I need one (columnB) to be a copy of the other one (columnA). So, ... How would I go about fixing that? See Question&Answers more detail:os...

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

0 votes

946 views

1 answer

sql - Run multiple commands in sqlite manager

It's possible to run more than one command in the direct SQL execution in SQlite Manager? (useful if you insert a lot ... ("Peter", 29) ... Thx See Question&Answers more detail:os...

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

0 votes

933 views

1 answer

sql - Using EXCEPT clause in PostgreSQL

I am trying to use the EXCEPT clause to retrieve data from table. I want to get all the rows from table1 ... best to use the explain clause? See Question&Answers more detail:os...

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

0 votes

886 views

1 answer

sql - MySQL: Union of a Left Join with a Right Join

Say we have the following tables t1 and t2: t1: id | column_1 ------------- 1 | 1 2 | 2 t2: id | ... id ) Is there a better way to achieve this? See Question&Answers more detail:os...

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

0 votes

992 views

1 answer

sql - Deleting value using SQlite while doing an INNER JOIN

I am trying to delete all voters from a voters table where they are not registered as a democrat or republican ... delete with a JOIN statement See Question&Answers more detail:os...

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

0 votes

843 views

1 answer

sql server - SQL select, pad with chronological missing months

Notice the 2015-02 and 2015-03 months are missing in the output from the following group by SQL. If there is ... char(7), t.MeterReadDate, 121) See Question&Answers more detail:os...

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

0 votes

733 views

1 answer

sql - How to use % operator from the extension pg_trgm?

I have my pg_trgm module installed. pg_trgm | 1.0 | extensions | text similarity measurement and index ... The ... run % or <-> operators? See Question&Answers more detail:os...

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

0 votes

971 views

1 answer

sql - Add 2 months to current timestamp

How can I add months to a timestamp value in Oracle? In my query, it's getting converted to date value instead: ... 01 00:00:00.000000000+00:00 See Question&Answers more detail:os...

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

0 votes

974 views

1 answer

sql - How to make string auto increment

I got 2 different table: Table1 ID AK001 AK001 AK001 (above should be AK001, AK002, AK003 and so on.... ... when table2 is updated. Please help! See Question&Answers more detail:os...

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

0 votes

947 views

1 answer

sql server - Find and Remove Repeated Substrings

I've a column in a SQL Server 2008 table where part of the string was accidentally ... should be alpharavocharliedelta See Question&Answers more detail:os...

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

0 votes

991 views

1 answer

sql - Nhibernate count distinct (based on multiple columns)

Basically, i have been trying to do this (count distinct based on two columns): select count(distinct ... .DistinctRootEntity).RowCount(); See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags