How to get the alternate rows or records from table in sql server

Total Page Preview: 000000022471

How to get the alternate rows or records from table in sql server

In this article I am going to explain How to get alternate row from table in sql server with expample using sample and CTE query.

Get the alternate row or record to Gender column:

---------------------Get the alternate row by the Gender--------------------

SELECT NAME, GENDER, ROW_NUMBER() OVER(PARTITION BY GENDER ORDER BY GENDER) AS R

FROM #PERSON ORDER BY R, GENDER DESC

Get the alternate row or record to Gender column Using CTE:

---------------------Get the alternate row by the Gender using CTE--------------------

;WITH PRS (Name, Gender, R)

(

SELECT NAME, GENDER, ROW_NUMBER() OVER(PARTITION BY GENDER ORDER BY GENDER) AS R

FROM #PERSON

)

SELECT NAME, GENDER FROM PRS ORDER BY R, GENDER DESC

Get Alternet Row or record In SQL Server

Get SQL Scripts for Create Tables and Insert Data for demo:

---------------Create table ------------

CREATE TABLE #PERSON

(

NAME VARCHAR(60),

GENDER VARCHAR(1)

)

--------------------------------- Insert record into table------------------------

INSERT INTO #PERSON (NAME, GENDER) VALUES ('Brijesh', 'M')

INSERT INTO #PERSON (NAME, GENDER) VALUES ('Rahul', 'M')

INSERT INTO #PERSON (NAME, GENDER) VALUES ('Saurabh', 'M')

INSERT INTO #PERSON (NAME, GENDER) VALUES ('Arti', 'F')

INSERT INTO #PERSON (NAME, GENDER) VALUES ('Jyoti', 'F')

INSERT INTO #PERSON (NAME, GENDER) VALUES ('Preeti', 'F')

Thanks !!!

Brijesh Kumar

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com

Comments

Bowes

10-Oct-2021

Excellent beat ! I wish too apprentice while you amejd your site, how could i subscribe for a blog site? The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear concept

https://bettinglex.co.uk/champions-league/

Relpy

Warrick

02-Oct-2021

I enjoy what you guys are up too. This type of clever work and exposure! Keep up the terrific works guys I've included you guys to my personal blogroll.

https://casinoran.xyz

Relpy

Click

26-Oct-2021

Hey! I'm at work browsing your blog from my new iphone 3gs! Just wanted to say I love reading your blog and look forward to all your posts! Keep up the excellent work!

https://movecasino.com/jack998-slots/

Relpy

DHRUV

14-Apr-2021

hi Brijesh , Request you to please explain the behaviour of the query.

Relpy


Please enter your comment.
Please enter your Email-Id. Please enter valid Email-Id
Please enter your name.

Notify me of new comments via email. Notify me of new posts via email.