Answer to Question #294126 in Databases | SQL | Oracle | MS Access for wyc

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 dsplay al details of students whose marks are between 80 to 95 inclusive

Posted about 6 hours ago

Answer 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 dsplay al details of students whose marks are between 80 to 95 inclusive

Posted about 6 hours ago