406 questions
2
votes
2
answers
91
views
Make a new column based on the count of rows, in an existing column, that meet a condition
My dataframe is called detections. One column is OBSERVER. That column contains the initials of 32 different people. Some of those observers are responsible for 1000+ observations (i.e. 1000+ lines ...
- 143
1
vote
0
answers
23
views
ADF - Row count validation before and after dataflow
I am wanting to verify within the pipeline that the row count before and after a dataflow matches, accounting for any rows which have been filtered out.
For example:
a) rowsRead = 500 b) rowsWritten = ...
- 11
0
votes
1
answer
175
views
Row count base on Date criteria
Currently, I am facing an issue in a date difference calculation. I need your suggestions on how I can solve this issue. I need to count rows if the value exists between my date slicer range.
In the ...
- 11
0
votes
1
answer
263
views
How can I get the number of rows from a refcursor in plsql?
I have an sp that returns 3 separate ref cursors.
Customer_sp(p_musterino=>1111,p_rc1 => p_rc1, p_rc2 => p_rc2, p_rc3 => p_rc3);
I need to get the number of rows returned from the first ...
- 3
2
votes
1
answer
804
views
count the rows of top 10 largest size tables in PostgreSQL
in this post, I can get the row count from nominated table.
Fast way to discover the row count of a table in PostgreSQL
SELECT count(*) AS exact_count FROM myschema.mytable;
But how can I list the ...
- 3,095
0
votes
1
answer
82
views
@@ROWCOUNT is returning always zero in stored procedure [duplicate]
Here is my stored procedure
/****** Object: StoredProcedure [dbo].[TestStoProc] Script Date: 21.09.2023 13:32:40 ******/
ALTER PROCEDURE [dbo].[PurgeSyncOperations]
-- Parameters for ...
- 11
1
vote
2
answers
84
views
Row count to repeat in a pattern BigQuery
I am trying to create a row count pattern that would look something like this
|Id | Row_Count |
|--- | --------- |
|1 | 1 |
|2 | 2 |
|3 | 3 |
|4 | 4 |
|5 | 5 ...
- 13
0
votes
2
answers
366
views
Why psycopg cursor.fecthone return a list of None if no row was hit from select query?
My function to query account by email:
CREATE FUNCTION get_account_by_email(account_email varchar(64)) RETURNS account AS $$
SELECT id,
name,
email
FROM account
WHERE account.email = ...
- 33
0
votes
1
answer
172
views
Pyspark: Adding row/column with single value of row counts
I have a pyspark dataframe that I'd like to get the row count for. Once I get the row count, I'd like to add it to the top left corner of the data frame, as shown below.
I've tried creating the row ...
- 127
0
votes
0
answers
51
views
Row Count in Selenium restricted to first 70 rows
I have a table on the webpage which gets populated with rows based on search-filters.
The number of rows vary from 1 to 200 base don above.
However, when the number of rows are more than 70, the ...
- 45
1
vote
3
answers
621
views
Optimal way to serialize a query as XML and to get the rows count, both using only one statement?
Writing a SQL Server database object, I was faced with the problem of to serialize some data to XML and to get the count of rows being serialized.
I wrote something like this using a CTE:
-- Way III
...
- 381
0
votes
1
answer
98
views
Need code to count only not-empty rows in html table
I have a javascript code to count records in html table, but it counts all and I need to count not empty only:
If I click the button it shows 5 rows, but I need to make count equal to 4.
Need java-...
- 1
0
votes
1
answer
133
views
Need to count number of rows of a Postgres table to test it in my Powershell script
I just have a short question.
I have a PowerShell script that insert rows into a Postgres table using \copy command.
No issue at load, everything goes well.
After the load done, I would like to query ...
- 29
0
votes
2
answers
115
views
How to sum up rows (that are not blank) from input values in a table using javascript
I've added input fields into a table. What I'm looking to do is to count all of the rows and add them into a table row total. Ideally I want these to have a value of 0.5 for each row that has an input ...
0
votes
1
answer
299
views
Insert Query: Column count doesn't match value count at row 1 [nextjs]
I've a form on my page where I want to be able to submit data into my database/table, but get the error. The amount of given values do match the given columns in the code, so now I don't know exactly ...
- 11