I have a table with different people that got different grades. I need to find the two persons with the highest grades. And if there is any ties, select them aswell. The only thing ive got right now is the…
I want to apply limit on Sequelize table declaration. This would actually limit the rows total of the table to 1 by forbidding to add more rows into it. How can I achieve this in the table model definition?
In my table Product in MySQL I would like to count how many Product_Id has been Saved in Fav, Purchased or Delivered. Then organize the result in rows with null or not null by Fav, Purchase, Delivery in column or…
I have a query that orders the result by a specific none-unique column. Now I want to get the first N rows after a specific ID (the primary key). I have a table similar to this: ID Size 0 3…
I have query which looks like: SELECT * FROM ( SELECT DISTINCT CASE WHEN user1_id = 1 THEN user2_id ELSE user1_id END userID,conversationId FROM conversations WHERE 1 IN (user2_id,user1_id))dt INNER JOIN users on dt.userID = users.id It returns conversationId and…
I have a WordPress website and following a change of theme I have to modify the structure of a thousand links present on about fifty pages. I would like to do it in SQL via PHPMYADMIN. Is there a way…
Show the provinces that has more patients identified as 'M' than 'F'. Must only show full province_name patient table : patient_id INT first_name TEXT last_name TEXT gender CHAR(1) birth_date DATE city TEXT province_id CHAR(2) allergies TEXT height INT weight INT…
I have a stored procedure where the column name is coming in the parameter as string - varchar How to convert this to a column name to query in the select/insert/update as column name should be colnName Thanks How to…
I have a large data table containing details by date and across 3 independent criteria with around 12 discreet values for each criteria. That is, each criteria field in the table is defined as a 12 value ENUM. Users pull…
Here is the query to find the address from a table where it matches to variable $fromCity, $fromCity= "324 West Gore Street, Orlando, FL 32806, USA"; $sql = "SELECT * FROM vendor_info WHERE mailing_address LIKE '$fromCity'"; $em = $this->getDoctrine()->getManager(); $stmt…