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

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

Exception deserializing the package "The process cannot access the file because it is being used by another process."

Temporary enable and disable SSRS subscriptions