Posts by Maikol Oliveira • 77 points
6 posts
-
1
votes2
answers841
viewsQ: Data in SQL ORACLE
How do I apply a function in ORACLE SQL that brings me only records for the current month? BS.: I have a date column in date format (e.g.: 13/09/18). In sql server I applied the function below and…
-
-1
votes1
answer2686
viewsQ: How to make a SE function in SQL
Good morning. How do I make a SE function in SQL server? For example, I have data in a column and when it is = '1';'masculino';'feminino'. You can help me please?
-
0
votes1
answer114
viewsQ: order by specific text
How do I make a order by by text criterion? I have a column with some ratings and wanted it to come in the order I determine. Example: 'carro1' 'carro3' 'carro5' 'carro10' 'carro2'…
-
1
votes1
answer34
viewsQ: Return the value to the left
good morning. A question, how can I return the results of a column that contains only the values to the left that start with the word 'car' for example? I am using sql server. Thank you.…
-
0
votes1
answer435
viewsQ: how to subtract column date with system date?
I have a date column data_novo and I want to know how many days the product is open, I have to make a subtraction account between the "system date" and the date that is in the column data_novo. And…
-
3
votes3
answers83
viewsQ: Select different value from "X" name
How do I select in a given column only the different ratings of "X"? I created select below: SELECT top 1000* FROM [tabela_clientes] WITH (NOLOCK) WHERE STATUS= 'pendente' and status_2= 'pagamento'…