Top "Rows" questions

Update multiple rows with different values in a single SQL query

I have a SQLite database with table myTable and columns id, posX, posY. The number of rows changes constantly (might …

sql sqlite rows

Converting Columns into rows with their respective data in sql server

I have a scenario where I need to convert columns of table to rows eg - table - stocks: ScripName …

sql-server rows

Is there a way to suppress "x rows affected" in SQLCMD from the command line?

Is there a way to suppress "x rows affected" in SQLCMD from the command line? I'm running an MSBuild script …

sql-server rows sqlcmd suppress

Get previous and next row from rows selected with (WHERE) conditions

For example I have this statement: my name is Joseph and my father's name is Brian This statement is splitted …

sql sql-server sql-server-2012 rows

How do I SUM DISTINCT Rows?

I'm struggling with a query where I need to SUM DISTINCT Rows. There has to be a way to do …

sql sum row distinct rows

GridView: How to set the number of rows to display

I would like my grid view to display only 3 rows any ideas on how I can achieve this? Thanks

c# gridview rows

unwrap postgresql array into rows

What is the fastest way to unwrap array into rows in PostgreSQL? For instance, We have: a - {1,2} {2,3,4} And we …

sql arrays postgresql rows

Drag down formula and change ROW references instead of COLUMNS

In excel I have sheet1 contains total every month. (please see image below) Then in my sheet2 it will display …

excel excel-formula rows drag

Remove NA/NaN/Inf in a matrix

I want to try two things : How do I remove rows that contain NA/NaN/Inf How do I set …

r matrix rows na

Adding a one dataframe to the end of another data.frame in R

I'm having difficulty adding one to the bottom of another data frame. I have one data frame (let's call it …

r dataframe rows