Posts by Bruno Bacelar • 55 points
6 posts
-
0
votes1
answer49
viewsQ: Connect columns from different tables
SELECT e.EMPLOYEE_ID AS 'ID' ,e.FIRST_NAME + ',' + e.LAST_NAME AS 'Name' ,(SELECT DEPARTMENT_NAME FROM HR.DEPARTMENTS WHERE HR.EMPLOYEES.DEPARTMENT_ID = DEPARTMENT_ID) AS 'Department Name' ,e.SALARY…
sql-serverasked Bruno Bacelar 55 -
0
votes1
answer20
viewsQ: How to add another column to my query found in another table
SELECT DEPARTMENT_ID ,(SELECT DEPARTMENT_NAME FROM HR.DEPARTMENTS) AS 'Nome do Departamento' ,MIN(SALARY) AS 'salario minimo' ,MAX(SALARY) AS 'salario maximo' ,CAST(AVG(SALARY) AS NUMERIC(8,2)) AS…
sql-serverasked Bruno Bacelar 55 -
0
votes2
answers99
viewsA: How to have a cycle interval, up to n and up to 0
I was able to solve the problem by adding a condition inside the for: for(int i=0;dados[4][i]!='\n';i++){ if(dados[4][i]=='\0'){ break; } if(!isdigit(dados[4][i])){ return 0; } }…
-
1
votes2
answers99
viewsQ: How to have a cycle interval, up to n and up to 0
In a validation function that passes the tests all will return 1, and if you enter one of the conditions will give return to 0. I want to cycle until the line breaks, so I’m using the interval:…
-
1
votes3
answers407
viewsQ: Check if a string is composed of digits
I want to check if my strings (which are stored in an array), are integer or not for example a for the fourth row of the matrix have the following code. #include <stdio.h> #include…
casked Bruno Bacelar 55 -
1
votes1
answer64
viewsQ: Read and split C files
I’m doing a project for the college, the code already reads the files and divides the lines taking into account the ";", how can I save these tokens in variables? struct informacaoFicheiroInput{ int…
casked Bruno Bacelar 55