Questions tagged as 'query'

Tagged questions
0
answers

Doubt Bring Specific Date - Oracle

In the query below you are bringing it that way. Data Inicial Data Final Dia da Semana 16/10/18 30/10/2018 3 Where this start date and end date is for a specific time period, and the day of the week in that cas...
asked by 31.12.2018 / 14:39
0
answers

Doubt Query Line - Oracle

In the query below you are leaving this way. Unidade Ordem_Compra CNPJ Aprovador Sim Boavista 29021 155454878787 Ivan Sim Boavista 29021 155454878787 Romel The question is: How do I leave o...
asked by 27.12.2018 / 19:12
0
answers

Different Value - Oracle Query

In the query below in column Valor_Total_da_Ordem it is giving a totally different value, much higher than it actually was to be. The value is giving 55990,62. Being that the correct value is to be 1333.11. What could have happened?...
asked by 27.12.2018 / 12:33
0
answers

Oracle Query Error

When executing the query below, the following error is occurring. By analysis, the error occurs when I place the sum. For what reason?    "ORA-00918: column defined ambiguously   00918. 00000 - "column ambiguously defined"   * Cause:   * Act...
asked by 14.12.2018 / 20:13
1
answer

wp_query returning the entire post.Returns only title

I have this code and when I put it on the home page it returns the entire post. I need to return only the title, date and thumbmail of the post, it is retrieving all post content ... function get_mais_lidos_semana() { global $wpdb; global $pos...
asked by 17.12.2018 / 13:13
0
answers

Indexes database - Problem with queries that use many tables

My database is slow, I activated slow queries, and the only query executed with more than 1 second of response (this is too much for my server) is as follows: SELECT 'user_id' FROM Wo_Users WHERE 'user_id' IN (SELECT 'following_id' FROM Wo_F...
asked by 12.12.2018 / 12:02
0
answers

Input of Excel data in mySQL database using PHP

I am performing data insertion in a Mysql database using PHP and an excel spreadsheet but I'm having trouble completing the insertion in the database. public function uploadFile(Request $request){ $conexao = \DB::table('tb_pwbi_analytics_ac...
asked by 05.12.2018 / 21:16
2
answers

Select Distinct is bringing duplicate data Mysql

Hello, I'm having problems with a query, and I need to bring only the last record of each id_face that has in the imagens table, but for some reason it's causing id_faces duplicates Follow my query: SELECT DISTINCT(...
asked by 04.12.2018 / 12:45
0
answers

Query pagination with LIKE function

Good afternoon. I am having an error in the query with pagination when I pass a search parameter. Here's the problem: When I'm on page 2 and search for an item on page 20 my sql does not return anything. Follow sql : SELECT * FR...
asked by 30.11.2018 / 17:12
0
answers

MongoDB order find () per regular expression

Good afternoon. I am stuck in the following scenario: I have a database (mongodb) of names, and I need to do a search using regex (so far ok). Let's assume the bank is this: [{id: 1, Nome: "Luiz Claudio"}, {id: 2, Nome: "Luiz"}, {id: 3, Nome:...
asked by 13.11.2018 / 01:14