Recent questions tagged SQL

0 votes

300 views

1 answer

I have to select the top 25 records from a table according to the column Num. There are two issues. First ... in just one SQL statement? See Question&Answers more detail:os...

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

0 votes

318 views

1 answer

sql server - SQL conversion from varchar to uniqueidentifier fails in view

I'm stuck on the following scenario. I have a database with a table with customer data and a table where I ... point me in the right direction? See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - How to insert with where clause

I am using the following query to insert values into one field in table A. insert into A (name) values (' ... please provide me a correct way. See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

sql - Remove blank-padding from to_char() output

I generate a view from this: create or replace view datetoday as select to_char(dt, 'yyyy-mm-dd') as date, ... is fixed, the comparison fails. See Question&Answers more detail:os...

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

0 votes

383 views

1 answer

sql server 2008 r2 - How to perform SQL Roll back from transaction logs

I have transaction log file that goes back 6 months. I need to roll back everything that happened after 5/20/2013 ... me on how to do this? See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql server - How to return empty groups in SQL GROUP BY clause

I have a query to return how much is spent on-contract and off-contract at each location, that returns ... BY Location ASC, ContractStatus ASC See Question&Answers more detail:os...

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

0 votes

227 views

1 answer

sql server - Using 'IN' with a sub-query in SQL Statements

Are there any performance issues of using "IN" keyword in SQL statements in places where we can use JOIN? SELECT ... IN (SELECT Id FROM xxx) See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

sql server - SQL Convert Week Number to Date (dd/MM)

I am trying to convert the week number (for example: 21) in SQL-Server to the date (from the Monday of ... is appreciated. Thank you in advance. See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - Access substitute for EXCEPT clause

How can I get the same result I would get with the SQL code below in ms access? It does not recognize the ... TC.Cod_Prof); Thanks in advance! See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - Understanding Oracle aliasing - why isn't an alias not recognized in a query unless wrapped in a second query?

I have a query SELECT COUNT(*) AS "CNT", imei FROM devices which executes just fine. I want to further restrict ... "CNT" in the second query? See Question&Answers more detail:os...

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

0 votes

580 views

1 answer

sql - How to fix Ora-01427 single-row subquery returns more than one row in select?

When i execute the following query, i get the message like "Ora-01427 single-row subquery returns more than one row ... it returns 100 rows... See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - How to count distinct records

Could anybody please help me on SQL command? I have a table (tbl_sActivity) that have below data: user_id | ... at this stage for days. See Question&Answers more detail:os...

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

0 votes

312 views

1 answer

sql - mysql conditional join depends on a column

I'm trying to implement a generic notification system.. I have a data structure like this; notification_base:id,type, ... it's like pseudo code See Question&Answers more detail:os...

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

0 votes

246 views

1 answer

sql - Is it possible to have a tableless select with multiple rows?

A SELECT without a FROM clause gets us a multiple columns without querying a table: SELECT 17+23, REPLACE ... s more theoretical than practical. See Question&Answers more detail:os...

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

0 votes

301 views

1 answer

sql - Setting up foreign key with different datatype

If I create two tables and I want to set one column as foreign key to another table column why the hell ... useful to have different data types. See Question&Answers more detail:os...

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

0 votes

326 views

1 answer

sql - MS-Access -> SELECT AS + ORDER BY = error

I'm trying to make a query to retrieve the region which got the most sales for sweet products. 'grupo_produto ... clause? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql - Does INNER JOIN performance depends on order of tables?

A question suddenly came to my mind while I was tuning one stored procedure. Let me ask it - I have two ... are using Microsoft SQL server 2005. See Question&Answers more detail:os...

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

0 votes

253 views

1 answer

sql server - Enforce maximum number of child rows

If a database has a pair of tables in a typical "parent and child" fashion, is there a way to enforce (without using ... ,'bb'),('b5','bb') See Question&Answers more detail:os...

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

0 votes

227 views

1 answer

sql - pyscopg2: Is it possible to dynamically add %s in loop

I am trying to create a method in python insert records into a table passing in a list of column ... ): close_connection(connection,cursor) See Question&Answers more detail:os...

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

0 votes

252 views

1 answer

sql - Which is the best way to form the string value using column from a Table with rows having same ID?

I am using SQL Server 2008. This are my tables. Table A Aid int pk col2 col3 XYZID int Table B Bid int pk ... on Sequence foo-1,foobar-2,bar-3 See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql - deleting duplicate records

Is there some way by which i can delete duplicate record that exist in table.I just want one record and ... through a query . please suggest See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - Anyway for ADO to read updated data from a read-only excel file before save? (VBA)

I am using the following code to read data from Sheet1 of SAME Excel sheet. I load the data into the return array. The ... '>> "Col5:6" End Sub See Question&Answers more detail:os...

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

0 votes

283 views

1 answer

sql - Find all members in a tree structure

I have inherited a tree type table in this format StatementAreaId | ParentStatementAreaId | SubjectId | Description -- ... if that helps. Thanks See Question&Answers more detail:os...

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

0 votes

325 views

1 answer

sql - split string into several rows

I have a table with a string which contains several delimited values, e.g. a;b;c. I need to split ... and query against that temporary table. See Question&Answers more detail:os...

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

0 votes

376 views

1 answer

sql server - select bottom rows in natural order

How can I select the bottom X rows of a table, based on natural order? I can't do "ORDER BY DESC...", since ... .. I'm using Sql Server 2008 R2. See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql server - Reverse the order of words in T-SQL

I would like to know how (if it is possible) to reverse the order of words returned from a T-SQL string ( ... in a backwards (DESC) order. See Question&Answers more detail:os...

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

0 votes

29.8k views

1 answer

sql server - Data type differences between PHP sqlsrv driver and PDO driver

Here I am using sqlsrv: $conn = sqlsrv_connect("192.168.1.102,1433", array("Database"=>"RF_User", "UID"=>"rfo ... it also doesn't find the row)? See Question&Answers more detail:os...

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

0 votes

259 views

1 answer

sql server 2005 - Sql Query Pervious Row Optimisation

Here is my table structure MyTable ----------- ObjectID int (Identity), -- Primary Key FileName ... incase you need more information Thanks See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags