Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
644 views
in Structured Query Language by (30.3k points)
closed by

Consider a table student with fields Reg No, Stud Name, Sex, Course, total score. Write Sql queries for the following:

1. Enter a Record 

2. List the Detail’s of all students 

3. Display Details of the student whose name ends with ‘Kumar’. 

4. List all Female students who got more than 50 marks. 

5. List all students who are studying either science or in Commerce group. 

6. List details of those students who are studying Humanities in the Descending order of their names

1 Answer

+1 vote
by (30.5k points)
selected by
 
Best answer

1. Insert into Student values. (52, ‘JOSE’, ‘Male’, ‘Science’, 500); 

2. Select * from Student; 

3. Select * from Student where name like ‘%Kumar’;

4. Select * from Student where sex=’Female’ and Total > 50;

5. Select * from Student where course = ‘science’ or course = ‘commerce’; 

6. Select * from Student where course=’Humanities’ order by name desc;

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...