Questions tagged as 'where'

Tagged questions
1
answer

Problems with Query Builder in Laravel 4.2

Hello, I am having trouble generating a query using the Query Builder of Laravel 4.2 , the difficulty arises from the need for resulting queries in the database to be inside of parentheses, below is the desired query: select * from 'EV_R...
asked by 05.12.2016 / 20:12
0
answers

Problems with Where

I'm using MariaDB and I have a problem in the WHERE clause of the bank. The query is inside Excel which brings me periods from the bank through the month filter. But I was asked to change for a period of time, but it is bringing me an empty...
asked by 14.12.2018 / 16:01
1
answer

Oracle where case

I need to create a condition in where according to boolean . If% of_% then I will select lines with final values larger than expected ( boolean = true , etc) if it is ConfirmedVolume > ExpectedVolume I select ever...
asked by 31.08.2018 / 14:39
2
answers

Filter in WHERE Postgresql

Good morning folks, next, I'm doing a standardization of some records here in the company. So there are 2 tables. Table A (old records) columns as: id_alvara | logradouro 1 | Rua Sete de Setembro n° 200 2 | Rua tal 300 3...
asked by 06.07.2017 / 15:11
0
answers

Ruby on Rails doubts

I have this def in models, checked with pry and have values arriving normally, however they do not save in the @inventory variable and below I put the class Inventory too, I wanted to know if anyone could give a help, since jah thank you. p> M...
asked by 17.07.2017 / 21:29
0
answers

How to find select with no where in a laravel application [closed]

I have a problem and I can not identify where the laravel is doing a select without where in a table with many records, can anyone help me?     
asked by 24.05.2016 / 03:36
1
answer

Why is my WHERE statement in MySQL not working?

I have the following SELECT, and in the WHERE clauses the amount of credit was only shown if > = 2, but even putting the condition, shows me everything. (fornecedor_credito.qtd_credito >= '2') AND (cadastra_oferta.qtd_estoque >= '2')...
asked by 22.07.2017 / 20:10
2
answers

How to do a select within another select in mysql

I need to get the smallest value of a column to use as a condition in where , but I do not know how to do that. The column I need is ordering , as below: SELECT p.pro_name, p.id, f.image as foto FROM #__osrs_properties p LEFT JOIN...
asked by 08.11.2018 / 17:35
1
answer

SQL query with OR gets slow

I have a query that does the search using: WHERE pt.product_name LIKE '%termo da busca%' Then I want the search to also look for the artist name and put: WHERE pt.product_name LIKE '%termo da busca%' OR ct.mf_name LIKE '%termo da busca%'...
asked by 24.04.2018 / 17:22
1
answer

Select deleted a record and searching for others with the same code [closed]

The product code I pass into the sql via php. For example $ cd_product = 2; I would like to list everything but the record for this product (cd_product! = 2). So far so good. But I would just like the records of the table (product_table...
asked by 27.01.2017 / 17:24