I want to identify and count uris that contain the following values ukpga ukla asp asc anaw mwa ukcm nia aosp aep aip apgb nisi mnia apni I have a column in the table that has a list of uris.…
I'm currently developing a SOAP service with several operations. Requests and responses are saved in a table called "message". Each Request and each Response is its own entry in the table and each Request/Response pair has a corresponding correlation_id. I…
Im developing a web application. I have Django for my backend and using PostgreSQL for my database. I am not sure if this is the best approach or not but: I want to create a database for each company and…
I have following two tables which I would like to inner join based on part of each column content in both tables is equal to a value. In below example I would like to inner join two tables where I…
@Query(value = "SELECT o.restaurant_id as restaurantId, YEAR(o.date_created) as year, MONTH(o.date_created) as month, " + " count(1) as tpn, sum(o.total) as tpv " + " FROM ordersDB.orders o " + " WHERE o.provider_id = :providerId " + " AND o.status !=…
I'm a beginner in SQL and I use MySQL database. I have a table called "employees". How to retrieve only those employees whose third or any letter after the third is "r"? I have to use the LIKE operator. What…
I am trying to replace multiple whitespaces from a column in Redshift(Postgres) Query used : Select replace(col_name,' ',' ') from table; above query is not working for multiple whitespaces only. I have tried replacing other characters in the same query,…
Trying to create a conditional unique index in postgresql but unable to do so and getting this error Query 1 ERROR: ERROR: cannot use subquery in index predicate LINE 3: WHERE ( ^ this is how my query looks like…
I'm creating a school sql system and have this table planning: Note that i have almost the same tables for students and professor, it only differs by course column. Is there a way to create like a unique users table…
How to order by timestamp and group based on score Entities starting with a prefix (say a1 are similar), but we need to pickup the one with the highest score, in this case a1-1 For a2 it should pickup a2-1,…