Data dodania Pytanie
2017-04-22 20:04 How to speed up SQL query with date GROUP BY? »
I have a normal SQLite database table called table1 with 7 columns and of course a rowid. The first column is an custom_id number, the second is date ...
(2) odpowiedzi
2017-04-22 13:04 Oracle sql constraint questions »
I'm having problems with creating a oracle sql script. How do I create these two constraints? If VID is null then FID has to be null as well (VID = ...
(2) odpowiedzi
2017-04-22 11:04 pass a query to row_to_json function inside a store procedure in postgres »
I am trying to write a store procedure where I pass a query into a stored procedure which will internally call the row_to_json function. We have multi...
(1) odpowiedzi
2017-04-22 07:04 how to set values from sql database to java textbox? »
When I try to access data from SQL Server, the data column is of type varchar. But I try to set it into textbox, I got these type of exception Conver...
(2) odpowiedzi
2017-04-22 02:04 PostgresSQL: table referencing only part of a composite primary key »
I am Creating a movie and tv show streaming service database(for school project) using Postgres 9.6.2. I am running into the following error: there ...
(1) odpowiedzi
2017-04-21 23:04 sql to create domino ordering records »
I have a list of transportation link and need to order them by from to. I know the original location, placeB record,from location, to location,... re...
(1) odpowiedzi
2017-04-21 17:04 How to select an entry and exit record for each user from same table »
I have the following table R_ID DATE Col_A Col_B Col_C 158 20161008 01 99 99 158 20161012 01 01 99 158 201610...
(3) odpowiedzi
2017-04-21 16:04 Postgresql transpose rows to columns »
I have this query select * from sales shop | date | hour | row_no | amount -----------+------------+-----------+--------+--------...
(1) odpowiedzi
2017-04-21 14:04 Detect specific string including wildcards and isolate wildcards in PLPGSQL »
Is it possible in PostgreSQL 9.4 (PLPGSQL) to detect if a string contains a certain string including wildcards and get the wildcards, ex.: IF NEW.my_...
(1) odpowiedzi
2017-04-21 09:04 Oracle Regular Expression-To match an exact word »
I need to search in a column named DESCRIPTION in a table which match the exact word ICE, Ice or ice. There may be other words before or after the key...
(2) odpowiedzi
2017-04-21 01:04 Oracle SQL - Select First n Distinct Rows »
In Oracle 12, we finally have a limit feature, so we can simply select distinct columnname from mytable fetch first n rows only; However, I am pres...
(2) odpowiedzi
2017-04-20 23:04 Oracle SQL - Query Time Limit »
In a similar fashion to how select * from mytable where rownum <= 1000; will give me the first 1000 rows of results of a query, is there a way t...
(1) odpowiedzi
2017-04-20 17:04 Oracle Rank() within (sub)group »
I am trying to get the correct rank within a subgroup and am having problems with the outcome. I need to get a rank of each time the group changes bas...
(1) odpowiedzi
2017-04-20 11:04 Put specific values in specific table cells from database. (Razor - html) »
<table class="prTable"> <tr> <th>Exercise</th> <th>1</th> <th>2</th> ...
(1) odpowiedzi
2017-04-20 02:04 get 3 peole have higher value from sql »
i have a table look like at the top. i want to show the 3 students that have higher value, i have tried command $higher= mysqli_query($connection,...
(3) odpowiedzi
2017-04-20 02:04 cfquery inside of cfoutput query results »
Looking for a more efficient way to insert records based on query results. Example: <cfoutput query="actionInfo"> <cfquery datasource="cfde...
(1) odpowiedzi
2017-04-19 23:04 Removing Duplicates from complex MySQL Select Query »
All my projects are stored in the com_projects table. Each project can have multiple locations, which are stored in the com_location table. The com_...
(1) odpowiedzi
2017-04-19 19:04 Purpose of Self-Joins »
I am learning to program with SQL and have just been introduced to self-joins. I understand how these work, but I don't understand what their purpose ...
(4) odpowiedzi
2017-04-19 14:04 how to insert dummy rows in sql without using insert query? »
I have the following query select '2016' as yr,warehouse as product,sum(answertext) p1 , round((sum(abc)/(select sum(abc) from [table 1])*100),2) p2...
(1) odpowiedzi
2017-04-19 13:04 How to Get the Shorthest Path in a Flightroutes-Table »
I have trouble in getting a statement to get all stopovers on a flight. I have table with flightroutes as below, which has a source-airport and a des...
(3) odpowiedzi
2017-04-19 00:04 Oracle SQL Get unique symbols from table »
I have table with descriptions of smth. For example: My_Table id description ================ 1 ABC 2 ABB 3 OPAC 4 APEЧ I need to g...
(3) odpowiedzi
2017-04-18 19:04 How to arrange id using IN clause? »
I have a mysql query which is like this: select * from tbl_post where id IN (16,18,14) and I want to display in order of 16,18,14 as in query. But ...
(0) odpowiedzi
2017-04-18 14:04 In postgres, what is the best way to do an AND with a join table? »
I have different categories of user, and a join table that allows users to be in more than one category. My join table is called categories_users and...
(3) odpowiedzi
2017-04-18 12:04 persist random items with no duplicates in constant time »
I've a an array in which I take out random items [a, b, c, d ,...] function getRandomItem(){ // return random item from array } I also have a S...
(1) odpowiedzi
2017-04-18 12:04 Optimisation in badly-performing query »
I have the following query which is working correctly, however it is running very poorly. I am suspecting that my issue is with the two comparison con...
(5) odpowiedzi
2017-04-18 12:04 oracle: sort by date and timestamp »
I select some data from three tables using union then I would like to sort them by date and timestamp (descending): select reportname as name, conve...
(3) odpowiedzi
2017-04-18 11:04 How to check hasMany relation record is empty in eloquent laravel »
I need to get those record who has not join with has many table my query like this $result = Recipes::select('id')->where("name", 'like', '%' . $i...
(2) odpowiedzi
2017-04-18 08:04 SQL count second column for-each unique row of first column »
I have this sample many-to-many table for students & subjects in a university student | subject ----------------- James | English James | Phy...
(5) odpowiedzi
2017-04-17 21:04 How to save and return JavaScript Object with Subarray in Normalized SQL »
I am using postgres-node, but I think this is a problem for anyone with javascript objects that have subarrays they want to save in SQL. I have a java...
(2) odpowiedzi
2017-04-17 21:04 How to implement per-user views of database? »
I have a postgresql table that contains widgets and their various attributes. Each widget belongs to a group of users, but each user in the group may ...
(1) odpowiedzi
2017-04-17 21:04 I have 2 tables I am looking to join, with no common column, but the information is needed »
I need to return the name and salary grade of each employee. I have two tables, Employee and Salgrade. Employee is set up this way - CREATE TABL...
(1) odpowiedzi
2017-04-17 20:04 Django implementation of default value in database »
I had a field on a model with was: class SomeModel(models.Model): some_field = models.CharField(max_length=10, null=True, blank=True) Then I ch...
(1) odpowiedzi
2017-04-17 11:04 MySQL Update using INNER JOIN with ORDER BY and LIMIT »
I'm trying to do an update using an inner join with limit and order by (although the order by is not essential. From what I have read up the standard ...
(2) odpowiedzi
2017-04-17 08:04 Select dates between date range and sum over a column »
I have the following tables: Let's assume the first table represents a booking made by a customer for a hotel. +------------+-----------+---------...
(1) odpowiedzi
2017-04-16 23:04 Theoretical evaluation of SQL query cost »
I need to evaluate a SQL query in theory by analyzing the results and the number of lines looked upon. Any link to information online is welcomed as I...
(1) odpowiedzi