Recent questions tagged SQL

0 votes

836 views

1 answer

sql server - How to select a max row for each group in SQL

I want select countries with maximum value of 'Value' for a 'grpid'. Also already selected 'Country' should ... 10 JP 231 198291290 15 See Question&Answers more detail:os...

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

0 votes

675 views

1 answer

sql server - Add a unique constraint of a sql table as foreign key reference to an another sql table

how to add a unique constraint of a sql table as foreign key reference to an another sql table in sql server 2005 See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

sql - Average difference between two dates, grouped by a third field?

So say we have 3 fields, username, start_date, end_date Users start and stop multiple records, eg below bob has ... AND group by? Any help? See Question&Answers more detail:os...

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

0 votes

878 views

1 answer

sql - TSQL strip date from datetime

What is the best way to strip the date from a DATETIME so only time is left to do a comparison? I ... rely on converting to character strings? See Question&Answers more detail:os...

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

0 votes

747 views

1 answer

sql - mysql - search timestamp by hour of day

I have a column named updatetime that is a timestamp. So, for example, an average looking value could be: 2011- ... updatetime ...... Thoughts? See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

sql - Compare strings as numbers in SQLite3

I have the following query in SQLite: SELECT * FROM t1 ORDER BY t1.field Where t1.field is a text column ... 10 goes before 2. Thank you. See Question&Answers more detail:os...

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

0 votes

918 views

1 answer

sql server - How do you get output parameters from a stored procedure in Python?

I've googled around a bit, but maybe I didn't put the correct magik incantation into the search box. Does anyone ... ) con.commit() con.close() See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

sql - mysql: searching BETWEEN dates stored as varchar

i would like to select * from table where dates between (some_date and another_date) the problem is that the ... /2010' for function str_to_date See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

sql - Inserting new columns in the middle of a table?

When one uses "ALTER TABLE tab ADD col", the new column gets added to the end of the table. For example ... solution would be best. Thanks. See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

sql server - Determine whether SP Parameter has a Default Value in T-SQL

Is there any way to determine from within SQL Server (I'm on 2012 FYI) if a SP's parameters have default ... SET NOCOUNT ON; SELECT @I END See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

sql - How to use 'LIKE' statement with unicode strings?

I am trying to execute a query with unicode characters. I was able to execute the normal equality query by ... Collation settings in SQL Server. See Question&Answers more detail:os...

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

0 votes

684 views

1 answer

sql server - ClassNotFoundException - com.microsoft.jdbc.sqlserver.SQLServerDriver

I have a web development project using local install of Tomcat 7. I am trying to connect to SQL Server 2012 ... Eclipse IDE can see the driver: See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Calculating how many days are between two dates in DB2?

I need to get the difference in days between two dates in DB2. I tried a couple of different queries but ... be greatly appreciate it. Thanks See Question&Answers more detail:os...

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

0 votes

807 views

1 answer

sql server - How to convert a byte[] into datetime in C#?

I have a field of type TimeStamp in database, which is converted in byte[] in c# code, and i need to ... .FromBinary(longVar); is this ok? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Is there a performance difference in using a GROUP BY with MAX() as the aggregate vs ROW_NUMBER over partition by?

Is there a performance difference between the following 2 queries, and if so, then which one is better?: select q ... the group by was faster. See Question&Answers more detail:os...

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

0 votes

712 views

1 answer

sql - How to prevent deletion of the first row in table (PostgreSQL)?

Is it possible to prevent deletion of the first row in table on PostgreSQL side? I have a category table ... to my problem in documentation. See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

sql server - nodejs mssql insert with parameters

I'm new to NodeJS where I'm trying to insert into a table with parameters so I can avoid SQL Injection and just escape any ... x =1; }) }) } ) See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

sql - MySQL queries are fast when run directly but really slow when run as stored proc

I've been trying to figure out what's wrong with a set of queries I've got and I'm just confused at ... use of variables (which is unavoidable). See Question&Answers more detail:os...

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

0 votes

907 views

1 answer

sql - dbms_metadata.get_ddl not working

I want to get the DDL of Table CARD_TABLE in XT schema SQL> select dbms_metadata.get_ddl('TABLE','CARD_TABLE',' ... VAT TABLE 7 rows selected. See Question&Answers more detail:os...

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

0 votes

672 views

1 answer

sql - How do I create a temporary table from a type?

Suppose I have some type: CREATE TYPE usr.NameList AS TABLE ([name] VARCHAR(MAX) NOT NULL); And now I want ... OF usr.NameList -- doesn't work See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

sql - Is it possible for me to include a sub report in a tablix row that is grouped by an ID?

Is it possible for me to include a sub report in a tablix row that is grouped by an ID and pass ... tablix iGoalID equaling dataset2's iGoalID See Question&Answers more detail:os...

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

0 votes

726 views

1 answer

sql - PostgreSQL, SELECT from max id

By using libpq on PG 9.1, I am trying to write query to get values from row with highest index 'my_id': ... . How to write such query properly? See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

sql server - Schema changes not updating in Intellisense in SQL 2008 (SSMS)

I've notice an issue - it feels like a bug but I suspect a 'feature' - in SSMS in SQL Server 2008. ... in the options but couldn't see anything See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

sql - How to create id with AUTO_INCREMENT on Oracle?

It appears that there is no concept of AUTO_INCREMENT in Oracle, up until and including version 11g. How can I ... auto increment in Oracle 11g? See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

sql - Convert mysql DATETIME column to epoch seconds

I have a column mysql datetime that is in DATETIME format. Is there a way to SELECT this column in epoch ... be the best to capture this? See Question&Answers more detail:os...

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

0 votes

814 views

1 answer

sql server - Attendance IN and OUT

Consider the following table structure and sample data - EmpID InputDateTime StatusINOUT ------------------------- ... 23 08:44 2018-05-23 08:44 See Question&Answers more detail:os...

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

0 votes

888 views

1 answer

sql - Get All punch in and out for each employee?

Expected Output: SL# Emp# Employee Name IN OUT 1 106 George Jacob 24/Sep/2017 8:08:00AM 24/Sep/2017 12:53: ... F ON A.eventid = F.event_entry_id See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

sql server - Handling non existent values in sql query expression for ssrs chart

I am using the following query in an ssrs line chart. It counts how many orders are recorded each month based ... ) GROUP BY MONTH(Ord.OrdDate) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags