I am currently selecting a number of rows, joining another table but can have duplicate entries. I want to remove the duplicates (which I have done), but I want to keep the one with the latest time (bidTime) and using MAX(bidTime) doesn't work. Using ORDER BY doesn't work because it needs to order by from the JOIN table. Maybe I need a subquery, but I'm not familiar with those. I...
1. Create high quality PPT template based on the attached proposal of our Brazilian Colleagues (appendix 1). In the appendix we’ve clearly marked which sections we like and what we want to improve/ expand. The PPT should consists of a multitude of slide template with several editable infographics. Please see detailed storyline + requests (appendix 2). 2. Create an image treatment style...
Hi, I have a query which is running very slow, especially when more user_ids (e.g. 10 ids) are added to the IN statement. I am looking for a DB expert to help me optimise this query so that it runs as fast as possible. Here is the query: [url removed, login to view] Thanks!
I need a question to be solved with Power BI Direct Query. You need to have experience with Power BI and Direct Query to be able to solve this question. I need a solution in Power BI and cannot accept solutions that involve significantly changing the data set.
...name, last name, email, company, phone number, city, and state of 2,000-3,000 CEOs, members of the office of the CEO, Chiefs of Staff, Executives in Corporate Communications, and Executives in Corporate HR. These people should come from fortune 1000 companies, located in the New York Tri-State area, that are growing or profitable. Preferably, global
We need a query to generate the quantity sold and the price for each product in prestashop for each year. I can provide a database dump. We need to be able to export in excel/csv like the below example, I should be able to change the year in the query, for example to generate results for 2015, 2016 and 2017 separately. Product | Quantity Sold
Hello Friends, I have developed a form to insert the values from Google maps using j query with single color for each record and successfully saving in the back end. Now I am unable to retrieve the inserted data with color I have saved and update the map / existing record. I will provide you the tables and queries related to that form. You
I'm interested in reframing 2 wood frame bathroom wall 10' x 9. I wish to modify the window size. Please advise if you can take this job. I'm located in Florida and the county is asking for a sign and stamp structural design.
3D Model : State Emblem of India. ~ Model must be 3d printable. ~ Size : 18 Inch ~ Require : 3D Model ( Format : step, 3dmax, sldprt, stl, (model must be editable.)
I have a query that it should finish in about 30 minutes but instead it just keeps running on end, it fills the filesystem and then die I need someone that knows SQL very well, has experience with columnar database and how they work (example no indexes etc) and that it can properly read and understand query plans I will provide the query and more
I need a WordPress query written to pull repeater entries that have a specific option selected from a custom post type. I have the custom post type and all of the fields created, including a select field that I need the entries to be queried by - just having some trouble with the code to display the correct results.
Who doesn’t love to save money, but imagine if you could get back all the money you have spent, each and every time you purchase, back in your account? Yes! For the first time in the history of shopping, we offer our members a 50% cashback scheme that puts back every single penny you have spent back into your account. We are Cashback E Market, a unit of Ajanthaa E World Pvt Ltd, establishe...