How to move the last row to the top in a table in MySQL?
I have a row in the following table which is the first row but added to the table at the end and now I'd like to modify the table in a way to show employee ids in order starting by…
Mysql – how to convert an sql view to table
I have a view and its taking longer time to execute so i need to write simple query to rather than view. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_party_make_subcat_size_map` AS select distinct `m`.`part_name` AS `material_name`,`pt`.`pk_id` AS `pk_id`, `pms`.`fk_party_id` AS…
Mysql – JOINs and WHERE clauses impacting GROUP BY performance
Resolved: I was misunderstanding how indexing works. The issue was that I only had single-column indexes and so by joining another table or adding a WHERE clause, SQL could no longer do a simple run through the index, but needed…
Postgresql – Postgres query to get one value in group by clause
uid created_date user_id 1 2023-07-05 05:50:00.000 1 2 2023-07-05 06:50:00.000 1 3 2023-07-05 06:50:00.000 1 4 2023-07-05 06:40:46.000 2 5 2023-07-05 06:57:46.000 2 6 2023-07-05 06:43:46.000 2 For example, above is the data. I am looking for output to have…
Postgresql – What is the most suitable data type for a column in a table?
Currently I'm trying to develop a PostgreSQL database schema, it has only 2 tables, one of which contains usernames. The difficulty is that for certain reasons I cannot store the username directly, so I have to store the hash (SHA256).…
Postgresql – How to find missing rows on two sides of a join?
In PostgreSQL, I want to run two tests: if there is a table in a specific schema which is not in the required_tables table if there is a table in the required_tables table which is not in the specific schema…
Postgresql – Extract epoch from column of timestamps in Postgres
What is the syntax to get the epoch from a timestamp column with time zone. I can use with time zone in the following way and it works as expected select extract(epoch from timestamp with time zone '1970-01-01 00:00:00.000 +00')…
Postgresql – Postgres truncating timestamptz value to 3 places?
In my postgres database I have a table I'll call users with a timestamptz type column updated_time. When I execute a select statement on this field I will get something like this - '2024-07-01 12:30:30.821 -0500'. However, if I turn…
Asp.net – Multiple tables query with repository pattern
I have an ASP.NET Web API project, and have implemented repository and unitOfWork patterns. I currently have a big SQL query that I want to implement in code, it includes a lot of tables and joins. My current solution is…
Postgresql – postgres- plsql function to get rows counts for specific columns with null data
i need to get rows counts for specific columns with null and insert the same rows count output into a table with result set of the query. For this requirement, i tried with below pl/sql code block in postgres but…