Questions tagged as 'query'

Tagged questions
3
answers

How to select all tables in mysql

What is the query that makes me query a certain database in mysql that brings me all its tables?     
asked by 11.03.2016 / 18:23
4
answers

Select from previous months

I need to select in data from previous months, month by month. My query looks like this: SELECT * FROM VIEW_INCD WHERE MONTH(DH_CRIA_INCD) = DATEPART(mm,GETDATE()) - 1 AND YEAR(DH_CRIA_INCD) = YEAR(GETDATE()); Okay, I select only t...
asked by 08.08.2018 / 15:19
2
answers

Enum as Parameter NamedQuery Hibernate

Is there any way to pass as a parameter in a NamedQuery the value of Enum . public enum TipoConta{ CREDITO("Cartao de Credito"), DEBITO("Cartao de Debito"); private final String descricao; TipoConta(String descricao) {...
asked by 15.01.2015 / 16:33
3
answers

SQL Query - Doubt Condition Dates

Everyone, good afternoon! I'm having trouble with the query below. I want you to bring all the tasks only when the maturity (field) of them is equal to the month after the opening date (tardata). However, nothing came up in the query. select *...
asked by 01.12.2017 / 19:04
3
answers

How do I store more than one value in an "SQL variable"?

I work with a system that has a very limited report builder. The reports are basically restricted to a SQL query. I need to present a query in a report that, in my query, the user is being informed by a multi-selection parameter, I will expl...
asked by 29.11.2018 / 01:04
1
answer

How to return the expected result in this query?

Good afternoon, guys. The case is as follows: I have a table with 2 blogs of category "automovel" and part of the title "Hackers" then whatever my query, can not return more than two results combining the "title" and "category" . Can you help me...
asked by 19.11.2016 / 15:26
2
answers

Pass value typed to another method

I'm having a question about passing a typed value. I'm posting here because I stayed the whole afternoon yesterday and did not find anything. In 1st class: public class CompararLogin { private String nome; public String cpf; Scanner scan...
asked by 10.06.2015 / 14:21
2
answers

Count values with specific data in MYSQL

I have a huge list of values that I need to count, the example is, I have 4000 barcodes and in those 4000, 2000 are marked in the without stock column with a yes . Better explanations In the total bar code count I use this code...
asked by 02.05.2016 / 18:05
1
answer

Get data from fields of the same name but from different tables

I have a select that it fetches data from three different tables, but has some fields in common between these three tables. My question is how to get the data from this field, which has the name in common with the other tables. My select look...
asked by 10.12.2014 / 14:32
2
answers

Parameter passing between pages

How to pass parameter between pages in Windows Phone 8 .1? In the previous version it was done like this: Page 1: private void Button_Click(object sender, RoutedEventArgs e) { string uri = string.Format("/Pagina2.xaml?nomeParame...
asked by 28.11.2014 / 18:09