How to fetch alternate records from a table in sql server


CREATE TABLE STUDENTS
(
      STUDENT_ID int NULL,
      [STUDENT_NAME] [varchar](50) NULL,
      DOB date NULL,
      DEPARTMENT_ID int NULL,
      DOJ date NULL
)

INSERT STUDENTS (STUDENT_ID, STUDENT_NAME, DOB, DEPARTMENT_ID, DOJ)
VALUES (1, N'BALACHANDAR', '1983-10-28', 2, GETDATE())

INSERT STUDENTS (STUDENT_ID, STUDENT_NAME, DOB, DEPARTMENT_ID, DOJ)
VALUES (2, N'PREMKUMAR', '1986-06-17', 1, GETDATE())

INSERT STUDENTS (STUDENT_ID, STUDENT_NAME, DOB, DEPARTMENT_ID, DOJ)
VALUES (3, N'MADHUSOODHAN', '1988-06-30', 3, GETDATE())

INSERT STUDENTS (STUDENT_ID, STUDENT_NAME, DOB, DEPARTMENT_ID, DOJ)
VALUES (4, N'SAGARBABU', '1995-10-05', 4, GETDATE())

INSERT STUDENTS (STUDENT_ID, STUDENT_NAME, DOB, DEPARTMENT_ID, DOJ)
VALUES (5, N'SRAVANTHI', '1988-04-06', 5, GETDATE())

SELECT * FROM STUDENTS



SELECT * FROM STUDENTS WHERE STUDENT_ID%2=0

SELECT STUDENT_ID,STUDENT_NAME,DOB,DEPARTMENT_ID,DOJ
FROM(SELECT ROW_NUMBER()OVER (ORDER BY STUDENT_ID)AS ROW,* FROM STUDENTS)
A WHERE ROW%2=0



Comments

Popular posts from this blog

Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings

Failed to execute the package or element. Build errors were encountered

Add the Power BI app to Microsoft Teams