Data dodania Pytanie
2018-02-03 10:02 Sql - Filtering on certain category »
I am trying to write sql that would give me count of unique devices which appeared in category 'blue' and 'red' but not in any other category. Below...
(3) odpowiedzi
2018-02-02 12:02 Generic class where type can Parse strings »
I want to create a generic class where the type of the class can Parse strings. I want to use this class for any class that has a static function Par...
(3) odpowiedzi
2017-12-30 08:12 Undefined variable: keyword error in laravel 5 when using advanced where clause »
I am using advanced where clause with parameter grouping. Here's the example $users = User::where('role', 'admin') ->where(...
(2) odpowiedzi
2017-09-10 17:09 How to create stored procedures through migrations in laravel 5.3? »
I have created procedure through migration but its not throwing any result when I am passing string in where query. Here is my code CREATE PROCEDURE...
(0) odpowiedzi
2017-07-20 15:07 multiple select query with same where clause »
I have two type of select statement with the same complicated where clause. One - Returns transaction detailed data select field_1, field_2, field_3...
(4) odpowiedzi
2017-07-12 09:07 is there any difference between where company_id=1 and where company_id='1' in oracle? »
If I am enclosing bind value within single quotes in where clause, Am I doing a mistake? I just want to know is it good practice to put every value un...
(1) odpowiedzi
2017-06-19 17:06 Oracle sql MERGE INTO with a single where clause »
I have the following SQL code (this is how much I've got so far): MERGE INTO SCHEMA1.TABLE_1 table1 USING ( SELECT DISTINCT table2.colu...
(2) odpowiedzi
2017-05-23 14:05 lower() in where clause does not match pattern »
select version(); version -------------------------------------------------------------------------...
(1) odpowiedzi
2017-05-23 06:05 Single filter not working when where clause have specified value »
I set my datatable only show data which start with OQC. require('ssp.class.join.php' ); $joinQuery = "FROM `monitor` AS `a` JOIN `sym_category` ...
(1) odpowiedzi
2017-03-01 02:03 Where Clause with Less/Greater than after a Join »
I'm trying to combine a joins with a where clause but the where clause is not testing an equality, it is testing for greater than or equal. I know in...
(2) odpowiedzi
2017-02-07 01:02 Rails 4 nested where clause on joined table that has multiple associations »
I have an Order model that has TWO associations to a VoyageLeg Model (which then belongs to a Port) as below: class Order < ActiveRecord::Base b...
(1) odpowiedzi
2016-12-09 18:12 Efficiently order SQL results with multiple where clauses »
I have the following simple data model: User table: id (pk) name (varchar) Post table: id (pk) user_id (fk) title (varchar) description Comment ...
(0) odpowiedzi
2016-11-30 16:11 active record query order where first »
I am using c9 cloud ruby on rails and rails version is 5.0.0.1 I want to use active record query to select best rating restaurant and not have been ...
(2) odpowiedzi
2016-07-18 13:07 Open-Sql translated to native oracle sql chooses arbitrary indices by where clause? »
We spotted a strange behaviour during a customer project. The underlying database is oracle, so this question is flagged for as oracle, because we onl...
(1) odpowiedzi
2016-05-02 13:05 PSQL: Find record where JSONB field with array of hashes contains some case insensitive value »
I need to find all the records in the PostgreSQL database (9.5) where connections JSONB column with array of hashes containing some information. And ...
(2) odpowiedzi
2016-03-31 23:03 Find records in deeply nested associations with rails »
I have the following models: class Book < ApplicationRecord has_many :chapters end class Chapter < ApplicationRecord belongs_to :book ha...
(2) odpowiedzi
2016-02-26 20:02 PL SQL - Multiple column equality »
I'm trying to evaluate multiple columns to save myself a few keystrokes (granted, at this point, the time and effort of the search has long since nega...
(2) odpowiedzi
2016-02-08 20:02 Ordering the results based on the where condition »
Suppose that table1 has 3 attributes: first_name, last_name, and country. For example with the following tuples: John White Canada John Smith France ...
(2) odpowiedzi
2016-01-09 14:01 Long tail where clause at CodeIgniter or Ignited Datatables »
I am trying to write a long tail where statement which containing another select query and how I can do it. Currently, I am using Ignited Datatables L...
(1) odpowiedzi
2016-01-07 20:01 Best Practices for Where clauses »
I wrote a simple tic-tac-toe program in Haskell. It runs on the command line, has a one and two player mode, and implements a minimax algorithm when ...
(1) odpowiedzi