Recent questions tagged SQL

0 votes

398 views

1 answer

sql - Convert a string date into datetime in Oracle

How can I convert this string date to datetime in oracle. 2011-07-28T23:54:14Z Using this code throws an error: ... time in the column 28-JUL-11 See Question&Answers more detail:os...

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

0 votes

258 views

1 answer

sql - Determine Oracle null == null

I wish to search a database table on a nullable column. Sometimes the value I'm search for is itself NULL. ... m using Oracle if that matters) See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql server - SQL : in clause in stored procedure:how to pass values

I want to write a SQL Server 2005 stored procedure which will select and return the user records from the user ... write the stored procedure ? See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

sql - How to compare sqlite TIMESTAMP values

I have an Sqlite database in which I want to select rows of which the value in a TIMESTAMP column is before a certain ... +0200','test','test'); See Question&Answers more detail:os...

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

0 votes

554 views

1 answer

sql server - MS SQL "ON DELETE CASCADE" multiple foreign keys pointing to the same table?

I have a problem where i need a cascade on multiple foreign keys pointing to the same table.. [Insights] ... constraint Any ideas? Thanks Daniel See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql - left join turns into inner join

SELECT a.foo b.bar c.foobar FROM tableOne AS a INNER JOIN tableTwo AS b ON a.pk = b.fk LEFT JOIN ... why this happens? THank you very much See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql - How can I avoid ResultSet is closed exception in Java?

As soon as my code gets to my while(rs.next()) loop it produces the ResultSet is closed exception. What causes ... same DB, is this an issue? See Question&Answers more detail:os...

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

0 votes

343 views

1 answer

sql - concatenate two database columns into one resultset column

I use the following SQL to concatenate several database columns from one table into one column in the result set ... standard SQL doing this? See Question&Answers more detail:os...

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

0 votes

396 views

1 answer

sql server - Dynamic SQL results into temp table in SQL Stored procedure

The code is as follows: ALTER PROCEDURE dbo.pdpd_DynamicCall @SQLString varchar(4096) = null AS Begin create TABLE #T1 ... me on this problem? See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql server - Decimal values in SQL for dividing results

In SQL, I have col1 and col2. Both are integers. I want to do like: select col1/col2 from tbl1 I get the result ... can I do exactly to get 1.1? See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

sql - Does mysql have the equivalent of Oracle's "analytic functions"?

I'm looking for analytical function like PARTITION BY in MySQL (see the docs for more info) Analytic functions ... group. Does it exist? See Question&Answers more detail:os...

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

0 votes

411 views

1 answer

sql server - SQL query to find Nth highest salary from a salary table

How can I find the Nth highest salary in a table containing salaries in SQL Server? See Question&Answers more detail:os...

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

0 votes

223 views

1 answer

sql server - Is it possible to perform multiple updates with a single UPDATE SQL statement?

Let's say I have a table tbl with columns id and title. I need to change all values of title column: from 'a- ... be made - it can be anything). See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - CASE vs. DECODE

Referring to a previous question, i was wondering if its always possible to replace DECODE by CASE and which one is better for performance? See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql - Is a JOIN faster than a WHERE?

Suppose I have two tables that are linked (one has a foreign key to the other): CREATE TABLE Document ( Id INT ... engines (MySQL, etc...). See Question&Answers more detail:os...

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

0 votes

318 views

1 answer

sql server - Query comparing dates in SQL

I have a table with dates that all happened in the month November. I wrote this query select id,numbers_from, ... is by default yyyy-dd-MM See Question&Answers more detail:os...

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

0 votes

276 views

1 answer

sql - How to get the last row of an Oracle a table

I want to get the last row, which I inserted into a table in an Oracle 11g Express database. How can I do this? See Question&Answers more detail:os...

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

0 votes

264 views

1 answer

sql server - How to update and order by using ms sql

Ideally I want to do this: UPDATE TOP (10) messages SET status=10 WHERE status=0 ORDER BY priority DESC; In ... . Anyway how to circumvent this? See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql - CASE WHEN statement for ORDER BY clause

I am using SQL Server 2008 R2. I want the priority based sorting for records in a table. So that I am using CASE ... <> 0 at the same time. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - PostgreSQL convert columns to rows? Transpose?

I have a PostgreSQL function (or table) which gives me the following output: Sl.no username Designation salary etc.. 1 ... ... How to do this? See Question&Answers more detail:os...

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

0 votes

308 views

1 answer

sql - How can you tell if a value is not numeric in Oracle?

I have the following code that returns an error message if my value is invalid. I would like to give the same ... (value>7200000)) THEN ... See Question&Answers more detail:os...

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

0 votes

504 views

1 answer

sql query distinct with Row_Number

I am fighting with the distinct keyword in sql. I just want to display all row numbers of unique (distinct) values ... . then it is not working. See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql server - Dynamic SQL to generate column names?

I have a query where I'm trying pivot row values into column names and currently I'm using SUM(Case...) ... then execute the resulting SQL code? See Question&Answers more detail:os...

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

0 votes

280 views

1 answer

sql - Group by alias (Oracle)

How to 'group by' a query using an alias, for example: select count(*), (select * from....) as alias_column ... . Why? How to group this query? See Question&Answers more detail:os...

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

0 votes

215 views

1 answer

sql server - SQL GROUP BY CASE statement with aggregate function

I have a column that looks something like this: CASE WHEN col1 > col2 THEN SUM(col3*col4) ELSE 0 END AS ... a subquery and group on that? See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

sql - How to check if a string is a uniqueidentifier?

Is there an equivalent to IsDate or IsNumeric for uniqueidentifier (SQL Server)? Or is there anything ... IsUniqueidentifier(column) = 1 See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql server - BULK INSERT with identity (auto-increment) column

I am trying to add bulk data in database from CSV file. Employee table has a column ID (PK) auto-incremented. CREATE ... row 2, column 1 (id). See Question&Answers more detail:os...

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

0 votes

322 views

1 answer

sql - Does DB2 have an "insert or update" statement?

From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is executed. ... like to avoid that if possible. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags