I am trying to show the number of quotes won as a percentage of the total number of quotes in a time frame. For example. I have a total of 294 quotes and 173 of them are won. The result I am looking …
Tag: sql
All categories for each week and group
Hi I have a data source as such Data: Weeknum Group Priority Total 202106 A High 10 202106 B Medium 15 202107 A Medium 88 Priorities: Priority High Medium Low The data has already been grouped such that each weeknum+group+priority is unique. What I need to do is return the full list of priorities for each wee…
How to add counter id column based on several columns on SELECT query Postgresql
I would like to create a column with counter number based on question_id and matrix_question_id this is my query: and this is the result I would like to create a new column as id_counter represent id counter base on question_id and matrix_question_id and I wish the result like this Answer What you need here i…
Django complex partitioning & ordering for tree Table
I’m using Django with PostgreSQL as my Backend-Stack for an application of which the main feature is a complex, multilevel table displaying annotated time-series-data for different products. So …
Find rows that have characters other than a plus (+) sign or number in a phone field
I want to find all rows in a phone column that have any character other than a plus sign (+) or numeric digit. It can be any character like slash, space, bracket, alphabet or any other character. The column has phone numbers, but may rows has space, brackets and slashes. I want to see those. Like: But theses …
Oracle SQL Pivot with Conditions convert rows to columns
I have the a table ITEM_SF with the following data I want to convert the data into Columns with a few conditions: My desired result is to show Charges, Discounts , Amount Paid and Tax Charges include (BookFees, HealthFees,RegistrationFees,SSCFees,TuitionFees,GeneralFees) Charges , Discount is Sum of ITEM_AMT …
MySQL get the SUM of different currencies
In a MySQL database To get the SUM of a column I just do: Is it possible in only one SQL request to get the SUM of orderamount_total of the different curriences defined in the column currency? Answer You just need a group by
Unable to replace the hour in datetime using SQL
Unable to replace the hour part in date-time. The change is reflecting in both hour & year. Please help in rectifying the code. Expected output = 2021-02-13 11:35:32.337 Actual output = 1121-02-13 11:39:11.347 Expected output = 2021-02-13 22:35:32.337 Actual output = 2221-02-13 22:38:13.223 Answer REPLACE…
how to fetch email address from oracle database
Hi All i am trying to fetch certain email patterns from oracle db 11g i have used the below queries Unfortunately i have to scan through the complete schemas in order to fetch the value (@pqr.de) where ever it exists in which ever column and table it is residing , ideally this activity is to list out inactive…
How can I find the right size box for each product?
I am sorry for re-uploading this quesiton, but I really want the answer. Kindly allow me to ask this question again and hope your kind support. The question is to find the right size box which allow the logistic business to save the money when shipping. We have 2 tables which are boxes and products. Boxes tab…