Answer to Question #294080 in Databases | SQL | Oracle | MS Access for Manik

Question

Ques- create a SQL query .....on

Table : STUDENT

Admno 101 , 102 , 103 , 104 & 105

Name

Ayushi

heena

Jitender

meena

Marks

52, 95 , 89 , 65 ,98

1) Write a create table query

2) To displey al details of all students.

3) To dsplay al details in descending order of marks.

4) To display admno and name of all students whose name starts with 'A.

4 To display the maximum and minimum marks from the table students

5) To display al details of students whose marks are between 80 to 95 inclusive

Answer 1

Create table STUDENT (name VARCHAR(20), ADMNO int, Marks int ;
Select * FROM STUDENT;
Select * FROM STUDENT ORDER BY marks DESC;
Select * FROM STUDENT WHERE NAME LIKE 'A%';
Select MAX(marks), MIN(marks) FROM STUDENT;
Select * FROM STUDENT WHERE Marks BETWEEN 80 and 95;