Questions tagged as 'sql'

Tagged questions
1
answer

With which databases is Apache Atlas compatible?

Apache Atlas has compatibility with which SQL and SQL databases I'm doing a job, and I could not find anything about     
asked by 17.05.2018 / 18:17
1
answer

Syntax error while testing the query in phpmyadmin [closed]

Error resolved. Query SELECT i.codiniciativa, te.nome as nome_tema, te.codtemaestrategico as cod_te, p.observacoes as per_obs, te.sequencia as tem_sequencia, p.sigla as per_sigla, p.nome as nome_perspectiva, p.co...
asked by 31.08.2016 / 22:09
2
answers

Add a line at the end of the query in MS-SQL

I have a query and it returns the following table: I would like to know if you can add another line (in this case 3) to make the difference between the two years. I wanted a new line that would give the difference of the two values o...
asked by 27.10.2015 / 17:08
1
answer

Selecting a data in a table that is not with you in another [closed]

Hello, I'd like to know how to draw a field that I do not have on another table. logically would be like this "selects code of the document in table x where the code of the document does not exist in table and";     
asked by 13.08.2017 / 16:05
1
answer

syntax error, unexpected 'if' (T_IF) [closed]

What is the error? $sql = "SELECT item1, item2, item3 FROM tab_exemplo WHERE" if (isset($item3)) {echo 'quartos LIKE :A';} if (isset($item2) || isset($item1) || isset($item4)){echo 'AND'} if (isset($item4)){echo 'garagens LIKE :B';} if (isset...
asked by 21.08.2016 / 23:51
1
answer

Error in SQL query with PDO

I can not make the query, when I try to do it, I get the error: Erro PDOStatement Object ( [queryString] => SELECT userid FROM usuario WHERE email=:email and senha=:senha ) <?php require_once('conexao.php'); // @$email = $_POST['emai...
asked by 14.03.2018 / 21:41
1
answer

What is worse about a 'where' or 'join'? Which is more expensive?

What is worse than where or join ? Which is more costly?     
asked by 15.04.2016 / 13:58
1
answer

how do I join inner join with these tables?

How would the SELECT query in Mysql of the Inf_musics table be?     
asked by 16.02.2018 / 03:17
1
answer

SELECT SQL WITH WHERE "DOUBLE" [closed]

I am trying to query the MySQL database with the following syntax SELECT id, codigo, faca, descricao, vendedor, imagem FROM produtos WHERE sit = 1 AND descricao = ESTE Until this part it works perfectly: SELECT id, codigo, faca, descr...
asked by 16.08.2018 / 18:32
1
answer

Help with Query [closed]

I have the following SELECT in SQL Server SELECT FTags.DateAndTime, TAGS.TagName, TAGS.TagIndex, FTags.Val FROM TagTablePoços TAGS INNER JOIN FloatTablePoços FTags ON FTags.TagIndex = TAGS.TagIndex WHERE TAGS.TagName = '[AGUA]FT[1].O...
asked by 14.03.2018 / 14:20