I found this picture in a document. It shows the queries running on a given SQL database. It looks similar to DBeaver software. However, I couldn't find a way t
I'm trying to insert into database a list (that I extracted from a file) with 3 columns: log_time log_type message I used this code: #database connection try:
I want to generate the below result and here is my query SET @count:=0; SELECT Workout.created_by, SUM(Workout.training_load) as TL, FB_User.name from FB_Worko
First question posted here so apologies if it is the wrong place! I'm attempting to pivot data in SSMS based on the below sample data that i have as an example
I need to translate the postgresql query below select distinct on (name) * from users To seqelize query / condition . Currently I am just selecting all users f
I have csv file which has data as in following format(data has converted from rrd to csv) ..... ...... <database> <!-- 2022-04-26 22:04:00 +0530 /
I tried to import an Excel file in the database,but the dates are shown as 5 digit numbers 44605 representing 2/13/2022.What can I use to conv
I have this table Customer Amount Date Period Group 77766 50 2022-02-28 1 2 77766 20 2022-03-31 2 2 77766 30 2022-04-30 3 3 12345 50 2022-02-28 1 1 12345 20 20
I am trying to get a result for the query: SELECT product, exportcountry FROM is_exported_to CROSS JOIN is_produced_in WHERE product = cheese AND origin = 'Fran
My Check constraint conflicts when adding values, any answer to why it is wrong will be much appreciated. Here is the question: Ensure that the Student’s
I am trying to write a query to get the last 4 weeks (Mon-Sun) of data. I want every week of data to be stored with an individual and shared table. every week d
I want to calculate total followers of a person from follow and unfollow table using SQl. Form of table are as follows Follow table: Unfollow table: My tries:
I'm monitoring the slowest queries to my databases and this one can't be indexed: USE [Project] SELECT TOP 10 t.NAME AS TableName, t.object_id, mai
In Pandas, you can get an overview of the table (mean, quantiles, count and count of unique values) for all columns by using the following method: pandas.DataFr
I am trying to find the latest update of a particular row from a bunch of rows per uuid. For that we use row_number() over a partition as shown below, "row_numb
I have structure data like this, I'm using SQL Server: ID User_ID CheckinTime Date 1 110 "2022-03-25 06:30:29" "2022-03-25" 2 110 "2022-03-25 12:12:31" "2022-
I have structure data like this, I'm using SQL Server: ID User_ID CheckinTime Date 1 110 "2022-03-25 06:30:29" "2022-03-25" 2 110 "2022-03-25 12:12:31" "2022-
Is there any way to migrate multiple columns data of table to only one column of other? I need to migrate the data of table 1 subject varchar(45) body
Problem background I am trying to pin down to what condition(s) are causing no records / rows the most, so to allow me to find the root cause of what data in th
I'm looking for the efficient way to store week days and times of each event. How do I achieve the following result Events table id name dates rel_id 1 hello w