Forum

Share:

Notifications

Clear all

How can you fetch alternate records from a table?

Last Post

RSS

<img alt='' src='https://secure.gravatar.com/avatar/80e771abba56ad3d716bf0366a8ebb93?s=80&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/80e771abba56ad3d716bf0366a8ebb93?s=160&d=mm&r=g 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 12

kumar BI

Guest

Topic starter

Aug 04, 2020 11:04 am

(@kumar BI)

Active Member

Joined: 3 years ago

Table alternate records

Topic Tags

alternaterecords fetchrecordsfromtable

1 Reply

<img alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 47

Ram DBA

Guest

Aug 05, 2020 4:32 am

(@Ram DBA)

Eminent Member

Joined: 3 years ago

You can fetch alternate records i.e both odd and even row numbers.

For example-

To display even numbers, use the following command:

Select student from (Select row, students from student) where mod(row,2)=0

To display odd numbers, use the following command

Select student from (Select row, students from student) where mod(row,2)=1

Reply

Leave a reply

Share:

Forum Statistics

10 Forums

174 Topics

321 Posts

0 Online

1,386 Members

Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo version 2.2.2