I’am doing my program and i need login and register system. My register system is working but login not. I have done register system SqlConnection sqlCon = new SqlConnection(“Data Source = (LocalDB)…
How I can index this query in Postgresql?
I’m trying to index my query to optimize the execution time. I tried some b-tree, hash, GIN and GISP index but none of them have been used by the Postgres planner. And even when I define …
What does the Date(0000,00,00) function equal in a SQL environment?
I am converting a Crystal Report into a SQL query. I have an IF statement in Crystal where if {loanview.FUNDING_DATE} Date(0000,00,00)…. Is Date(0000,00,00) a current date? Because I see …
Plus sign in the select clause of an SQL
I am working on an old SQL written for Oracle. There is a part of the select clause that I do not understand, even after googling and checking the questions related to the + sign with the key words …
Using Case Statements As a Pivot – DB2 SQL
I want a list of motor carriers, with trailer equipment counts listed in separate columns. I am using case statements to categorize the different equipment types, but I’m getting multiple returns …
Remove character from dynamic string
I have a file with some junk values and i need to get rid of them while loading that file into a table. Giving here some example. File is semicolon separated, and last column has those junk values. …
Combining two columns of a table and returning it as a single column separated by a character
I’m using oracle sql developer for the first time. I want to create a view with two columns of a table combined and seperated by a slash. I have done this in ssms but when I write the same code for …
Get counts of rows for each joined table for each row in the main table
I have three tables in my database. The central table in the star schema is sendings with a PK column called id. Each sending record can have zero or more rows in the tables opens. sendings.id = …
select distinct window function in PostgreSQL
I have a data table like the following: How do you select the distinct continuities for each Longitudinal distance in a 10-step rolling window? Ideally, I’d want something in the Ideal output column …
Dividing by decimal values – rounding issue
I’m trying to divide two decimal values, in hope they will return the following; 1.132930. However, SQL appears to be rounding the value to 1.132931. The value returned before conversion is 1.1329305135951. The SQL code i’m using is as follows: Answer You can round the value before the cast as following: