Write query to select student from math department, Database Management System

Assignment Help:

Consider the table student and list names of students in the departments other than maths and computer.

SELECT std_name FRM student WHERE dept_name NOT IN
(‘Maths','Computer);

Related Discussions:- Write query to select student from math department

Isolation or independence-transaction , Isolation or Independence : The iso...

Isolation or Independence : The isolation property shows that the updates of a transaction should not be visible till they are committed. Isolation assurance that the progresses of

What is inheritance, What is inheritance? Define it in detail? Inheri...

What is inheritance? Define it in detail? Inheritance Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then i

Sub query in the update command, Sub query in the UPDATE command : Exam...

Sub query in the UPDATE command : Example : //Double the commission for employees, who have got at least 2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE

Explain categories of failures that occur in oracle database, Explain diffe...

Explain different categories of failures that occur in Oracle database? Categories of Failures - In Oracle database subsequent types of failures can occurred: Statement Failu

Create a table student with attributes student name, Question 1 Create a t...

Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations Insert details in to the table Update

Create student database and retrieve course taught by king, Create student ...

Create student database and retrieve course name taught by king? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (secti

Define- relational algebra, Define- relational algebra. The relational ...

Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

Managing Data in Databases, Answer SQL Queries to extract data from data ta...

Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.

Update operations, The Update Operations : Update operations are used fo...

The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

What is recursive closure and operation relational algebra, What is recursi...

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages