I have a data (dt) like the following: I want to rank them within a group, first by score (lower score is better) then concat customer_id if the 2 customers are in the same group with the same score, and same tag (NOT null) I need to rank them by phase (older phase is preferred) to produce a final list.
Tag: database
How to replace Over clause in sql version 4.9.5
I am trying to run a query to find the count and percentage of artisan based on gender. The query is running absolutely fine on the SQL server 8. But not on my live server which is 4.9.5. The below is my query. Answer In any database, you should be able to use:
How do i create a MYSQL database locally using Database folder downloaded from github
I know the above question is incomplete. Let me explain this in brief. I downloaded the repository from this github link https://github.com/datacharmer/test_db and as per instructions on readme file i …
How to show multiple tables list in MySql
How to show multiple table list in mysql I have a query that has two tables one for patients and the second one for patients who has tested for covid-19 I want to show all the patients either they tested or not If tested then show the result with his/her name It only showing the patients who has tested for
Sql Performance join Vs co-related Subquery
TABLE : employee (id,mid,join_date) Question – Find all employees who joined before their managers Query 1: Query 2: Which of them is correct? If both correct, then how is the performance? Answer They are both correct. Performance questions need to be tested on your data on your system. However, with a …
Simplification of SQL Query
SQL is not my specialty. I have a working query that accomplishes what I need it to, but I know there has got to be a cleaner way of accomplishing my goal. The query should return: – Name – Date of …
how to drop multiple functions in Oracle
I want to drop multiple functions from my database at a time in Oracle’s SQL developer. Is anyone has an idea how to create a script for that? Answer Well, the static option to drop the functions (sometimes considered more secure as you can double-check what you are removing) consist of two steps 1 R…
Where can i find msi table column properties?
Where can I find the information about the datatypes used in the above create statement? I need info on all the msi tables. Answer MSI SDK: This section in the MSI SDK lists the built-in MSI tables: https://docs.microsoft.com/en-us/windows/win32/msi/database-tables – see the Orca section below for more …
MySQL – Join tables to a custom list/array of values
I would like to know if it’s possible to join tables into a custom set of values in MySQL. For example, I have a set of dates (outside the database). I would like to get the matched joins in a single query so that I can easily loop through the result. Like: Data outside database Date 2021-04-08 2021-04-…
PHP select query print out numerous items from database [closed]
My Table So I want it to print off like Coffee Name: ColumbianPrice: 7.99 Total Sold: 3 Total earnings: 23.9 And then to repeat for each type of coffee Is there any web pages that allow me to do this …