Write a query to retrieve all the students details whose id's starting from 1001 to 1050.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Write a query to display students details whose STUDENT_ID is 119 OR COURSE_ID is 301.
- Write a query to display students details whose marks are greater than 80. Note: Choose the most appropriat...
- Write a query to display students details whose marks are greater than the student whose STUDENT_ID is 123.
- Write a query to get the details of all the students who are all enrolled in the same course as the student...
- SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > 80 What will be the output of the above query?
- Student Table:|Student_ID|First_Name|Last_Name|Subject| |---|---|---|---| |101|Ajit|Sharma|Physics| |102|Ra...
- SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > ( SELECT MARKS FROM STUDENTS WHERE STUDENT_ID = 123 ) ...
- SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE STUDENT_ID = 119 What will be the output of the above query? A...