Posts by william queiroz • 51 points
7 posts
-
0
votes2
answers1493
viewsA: Syntax difference between databases
There is a difference. It is worth searching in the user manual that make available on the web. In SQL Server the query mentioned is as follows. SELECT TOP 1 * FROM table ie the limit does not go in…
-
1
votes1
answer415
viewsQ: How to download PDF file from server in Ionic 2?
I’m using the MPDF_6_0 library to generate Pdfs files, testing unitarily works, but I can’t trigger it through the Ionic project. How to do this? Thanks to all of the community. import { Injectable…
-
0
votes1
answer62
viewsQ: How to get a string from a json?
I am developing an application and need to save in a variable of string type what comes in the server json. How to solve? export class InicioPage { users : any[]; vaga : any[]; nomes : boolean =…
-
0
votes3
answers38
viewsA: Select in each response different values with Mysql Database
SELECT * FROM ( SELECT `Unidade I` AS UN FROM NOTAS UNION SELECT `Unidade II` AS UN FROM NOTAS UNION SELECT `Unidade III`AS UN FROM NOTAS UNION SELECT `Unidade…
-
1
votes3
answers759
viewsA: The null value automatically becomes 0
SQL SERVER: SELECT ISNULL(CAMPO,'VALOR') FROM TABELA
-
3
votes2
answers932
viewsA: GROUP BY SQL error
Try this: SELECT d.department_id, d.department_name, MAX(jh.start_date), MIN(jh.start_date) FROM departments d INNER JOIN job_history jh ON jh.department_id = d.department_id GROUP BY…
-
-2
votes7
answers412
viewsA: Mount an sql query filtering data
SELECT id,nf,status,data FROM documents WHERE STATUS ='EXCLUDED'
sqlanswered william queiroz 51