Member Avatar for shraddha_patel

How can you get the alternate records from the table in the SQL?

  • 2 Contributors
  • 1 Reply
  • 199 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by rproffitt
Member Avatar for rproffitt

This could be done by putting the ROWNUMBER into your SELECT statement. As a clue consider:
WHERE RowNumber % 2 = 0 --Even
WHERE RowNumber % 2 = 1 --Odd

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.