package com.example.demo;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface QuestionRepository extends JpaRepository<Question, Integer> {
    @Query(value = "SELECT * FROM questions OFFSET :offset LIMIT :limit", nativeQuery = true)
    List<Question> getQuestions(@Param("offset") Integer offset, @Param("limit") Integer limit);
}