正规365体育投注

Questions tagged [sql]

正规365体育投注 Structured Query Language (SQL) is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used. If your question relates solely to a specific DBMS (uses specific extensions/features), use that DBMS's tag instead. Answers to questions tagged with SQL should use ISO/IEC standard SQL.

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

Matching literal percent in h2/postgres?

I have the following value in a db column: some%thing I'm using h2 and postgres, but can't figure out why this query, where I have escaped the % to perform a literal search, is not matching the row ...
0
votes
0answers
5 views

Getting Percent Complex Query Athena

I have do a complex query to get several values. Then show the percent of the second paramaters over the grand total. I have to do this for a large number of variables. Basically: Union rows counts ...
0
votes
2answers
8 views

Oracle SQL - Comparing Substring Against Multiple Columns

I have a table which has 20 similar text attribute columns, text1..text20. These columns are of type CLOB. I am looking to find rows where one of these text attribute columns contain a specific ...
0
votes
0answers
11 views

Please tell me how to write sql query to seacrh smart account number input format

User types first three digits of product code and account number without prefix zeros System automatically converts it into full account number in collection, transaction screen Example: Account ...
0
votes
0answers
7 views

Performing update operations while backing up a database will the changes be reflect in the backup or not

I am restoring my database backup(SQL database) and it is running for 10 Min in the meantime if there are some updates to the database, will the changes will come into the backup.
0
votes
0answers
16 views

Sql query returning value from one row, but not another

Trying to return the value from a query, each of the queries below return a value when I run them individually in MSSMS: SELECT TOP 1 QUERY_NUMBER FROM CFG_QUERY_SETTINGS WHERE QUERY_NUMBER = 443 ...
0
votes
1answer
13 views

sql query to check minimum 2 records exist

i have a view like this : select Horse_Name, LevelName, TYPE_NAME, Event_Name, Result_Name from V_Horse_Transaction my result is like this : Horse_Name LevelName TYPE_NAME Result_Name DXB-...
0
votes
1answer
15 views

Subquery returned more than 1 value - STIntersects

I have three tables 2x tables of observational point data with a point geom column (for different time periods) A table of hexbins across the study area, with a polygon geom column Both are in the ...
0
votes
1answer
12 views

Error - ORA-00979: not a GROUP BY expression but works when I remove f.film_no AS “Film Number”

SELECT f.title AS "Film Title",f.film_no AS "Film Number", MIN(c.fee) AS "Lowest Contract Cost" FROM film f, contract c WHERE f.film_no = c.film_no GROUP BY f.title HAVING MIN(fee) > 7000000; ...
2
votes
1answer
28 views

sql: filter datetime columns based on given intervals

I am facing an issue related to filtering out events that were active during a certain time interval i.e. 7 to 9 EventId StartTime EndTime 18 2013-04-...
0
votes
1answer
18 views

How to apply __contains to formatted date with django ORM?

I want to implement a database search and I need to filter queryset by date that contains search request. The problem is that users will see formatted date (like dd.mm.yyyy) and will expect search to ...
0
votes
0answers
13 views

How to group and limit outcomes data

I've the following query running on ms-access : select t1.[supplier code], t1.date1,t1.date2 from otifdatatoexport t1 left join otifdatatoexport t2 on t1.date1 >= t1.date2 and t1.[supplier code] =...
1
vote
2answers
18 views

SQL conditional summation

I have table "Readings" with the following schema: ---------------------------------------- | Id | DateTime | value | --------------------------------------- | 16 | 01/01/19 22:50:...
0
votes
1answer
11 views

How to optimize a pysapark code to cmpute the distance by USER?

I want to compute the average distance made by the ID in each zone. I am woking in pyspark and I am using geospark. My table looks like: +--------------------+--------+----------+--------------------...
-3
votes
1answer
24 views

How to fix an unexpected end of file error in php source code [duplicate]

I am just creating a login page. On this page when I try to login by entering username and password, it shows me unexpected end of file error. Please, anyone correct what is the mistake in the source ...

15 30 50 per page
1
2 3 4 5
35625