Row (2024)

What is a row?

A row is a single group of related data within a table. Relational databases contain tables with rows and columns (also known as records and fields, respectively).

Columns are vertical, and hold a list of values all from the same field. Rows are your horizontal elements in a table. The values in a row belong to different fields, but all refer to a single unit (like a row that contains information about one customer or one order).

Row vs. record vs. tuple

Technically speaking, a row is the underlying logical grouping of related data in a table, while a record refers to that same grouping within the context of an application. When it comes to inserting, updating, or deleting in SQL, you’re dealing with rows, not records. This is a pretty subtle distinction though, and most people use these terms interchangeably. You’ll sometimes see tuple used as well, which is a mathematical term for the same concept.

Figure 1 shows the Products table in Metabase’s Sample Database, with one row highlighted. This row contains information from several different fields, each value relating to one of the products in our inventory (in this case, the Enormous Aluminum Shirt).

Row (1)

Related terms

Further reading

Did this article help you?

Thanks for your feedback!

Row (2024)

FAQs

What are the two meanings of row? ›

A row is anything that's lined up, from the row of stitches on your knitting needle to the row of numbers on your spreadsheet. Row is also a verb meaning "to paddle." Row also means a noisy argument, but when you use it this way, it rhymes with cow, rather than toe.

Does row mean a fight? ›

: to have a row : fight, quarrel. Etymology. Verb. Old English rōwan "to propel a boat with oars"

What is a row in slang? ›

In British slang, a "row" refers to a heated argument or dispute between people. It's similar to a quarrel or a verbal confrontation. So if someone says, "They had a massive row," it means they had a big argument.

What is a row in a dispute? ›

1. a noisy quarrel, dispute, or disturbance; squabble, brawl, or commotion. verb intransitive. 2. to make, or take part in, a noisy quarrel or disturbance.

Is A row vertical or horizontal? ›

A row in a table or spreadsheet is a horizontal line of data, whereas a column in a chart, table, or spreadsheet is a vertical line of cells.

What is an example of a row? ›

A row is simply the horizontal arrangement of objects, side by side, from left to right. It could be people, numbers, or others, placed alongside each other. Have you observed how the desks and chairs are arranged in a classroom?

What is a synonym for row fight? ›

row (verb as in argue, fight) Strong matches. berate bicker brawl dispute jaw quarrel ream scold scrap spat squabble tiff wrangle. Weak matches. bawl out call on the carpet tongue-lash.

What is the original definition of row? ›

First recorded before 950; Middle English rouen, rouwen, Old English rōwan “to go by water, sail, row”; cognate with Old Norse rōa; akin to Latin rēmus, Greek eretmón, both meaning “oar”; see also rudder.

Had a huge row meaning? ›

A row is a serious disagreement between people or organizations. [British, informal]

What is a synonym for the word row? ›

1 (noun) in the sense of dispute. Synonyms. dispute. brawl. quarrel.

What does duck a row mean? ›

To get your ducks in a row means to organize your tasks and schedule so that you are ready for the next step. There are a number of theories behind the origin of this expression. Real ducklings, of course, walk in a line behind their parent, and the expression ducks in a row certainly brings that image to mind.

What is in a row synonym? ›

consecutive nonstop short smooth solid straightforward successive true.

What does it mean to row a boat? ›

verb. When you row, you sit in a boat and make it move through the water by using oars. If you row someone somewhere, you take them there in a boat, using oars.

Is a row up and down? ›

Difference between a column and row

The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right.

What is the same meaning of row? ›

row (noun as in fight, ruckus) Strongest matches. controversy dispute quarrel squabble trouble. Strong matches. affray altercation bickering brawl castigation commotion disturbance fracas fray fuss lecture melee noise racket reprimand reproof riot rumpus run-in scrap set-to tiff tongue-lashing tumult uproar words ...

What do rows symbolize? ›

Each row of the Periodic Table of Elements, called a period, represents a new outer shell of electrons. The elements in each column, called a group, have the same amount of electrons in their outer shell, causing them to have similar properties.

Does row mean up and down? ›

Difference between a column and row

The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right.

Top Articles
Latest Posts
Article information

Author: Pres. Lawanda Wiegand

Last Updated:

Views: 6642

Rating: 4 / 5 (71 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Pres. Lawanda Wiegand

Birthday: 1993-01-10

Address: Suite 391 6963 Ullrich Shore, Bellefort, WI 01350-7893

Phone: +6806610432415

Job: Dynamic Manufacturing Assistant

Hobby: amateur radio, Taekwondo, Wood carving, Parkour, Skateboarding, Running, Rafting

Introduction: My name is Pres. Lawanda Wiegand, I am a inquisitive, helpful, glamorous, cheerful, open, clever, innocent person who loves writing and wants to share my knowledge and understanding with you.