Posts by Pedro Alencar • 89 points
12 posts
-
0
votes1
answer63
viewsQ: Sort Worksheet by something by clicking on "explore"
Good Afternoon everyone, I am trying to filter a specific spreadsheet. The idea is to filter a spreadsheet by a subject. By clicking Explore. Example "Worksheet to be automatically filtered" I put…
-
0
votes1
answer234
viewsQ: Convert VARCHAR to TIMESTAMP (AWS REDSHIFT/POSTGRESQL)
I have the following problem, at source I have the data coming as varchar example of data source in varchar format: 08:15:49 18:16:05 20:01:33 etc.... I need to reinsert this data into a new table…
-
0
votes1
answer266
viewsQ: SED replace the same case and minuscule occurrences with something
I am trying to replace occurrences "strings that appear in the document" with another value in the '' case; I have the following chunk of shell script code mkdir NOVO for script in *.sql do sed…
-
0
votes1
answer46
viewsQ: Trouble joining tables with UNION
I am trying to bring the top 3 of my table and also the last 2 placed, SITE TO EXECUTE SCRIPT This is my current progress that doesn’t work SELECT ('Podium: ' ||TEAM) as name FROM LEAGUE ORDER BY…
-
-1
votes1
answer123
viewsQ: How to give Count up to a limited value, "countar up to 90 on a table that has 100"
I assembled the following Query - "INFORMIX" SELECT COUNT(1) FROM (SELECT * FROM NOTA_FISCAL_NFE LIMIT 90); Which returns me the following error: An error occurred when executing the SQL command:…
-
0
votes3
answers1114
viewsQ: how to commit a cloned repository?
Yesterday I created a repository on github and gave some commits, today on another machine I already cloned a repository and I’m trying to commit changes but I can’t. process... I’ve done so far $…
-
4
votes1
answer2217
viewsQ: How to Bring the 2 highest values of each different id - SQL
I put together a spreadsheet to facilitate the understanding of my doubt. How to select only the 2 "two" largest room house tuition? I only managed to bring the highest value of each room, I wanted…
-
1
votes1
answer433
viewsQ: Is there any way to use logical operators with CASE/WHEN?
I am trying to use logical operators with CASE/WHEN in SQL but I am having difficulties, I need to present an answer if the result of the operation is less than 0 and another result for when the…
-
0
votes1
answer37
viewsQ: I cannot put result in SQL table
I want to put the result of this equation there where is 'RESULT1' I tried to do result1 = x But it didn’t work, I have little experience with SQL yet; SELECT (VA * VB) / VC FROM (SELECT 5 AS VA, 10…
oracleasked Pedro Alencar 89 -
1
votes1
answer320
viewsQ: Consecutive sum of a column in SQL
I wanted to calculate the data from a bad table as follows I have a price column 100 140 300 200 wanted to generate a second column that would make a consecutive sum of the previous table 100 240…
-
-1
votes1
answer57
viewsQ: Help with oracle database query
How to increase wages by 0.1% of those with lower salary than the AVG of your department This is the table I was able to average salaries per department: SELECT cod_departamento, AVG(VAL_SALARIO)…
oracleasked Pedro Alencar 89 -
1
votes1
answer232
viewsQ: Customize SQL query output
How do I customize an output of an example SQL query resulting from a sum of the columns OUTPUT: 23000 wanted to customize only this output to R $ 23.000