Tools

Title
Image Resizer Image Resizer Text to Speech

Comments

Post a Comment

Popular posts from this blog

SQL WHERE NOT in SQL.

Image
SQL WHERE NOT Explanation Understanding the SQL WHERE NOT Clause The WHERE NOT clause in SQL is used to filter the results returned by a query based on conditions that do not match specified criteria. Essentially, it excludes records that match the condition. It is the logical opposite of the conditions that are typically specified with the WHERE clause. Examples Consider a database table named Employees with the following columns: Id - Employee's ID Name - Employee's Name Department - Department where the employee works Salary - Employee's Salary To select employees who do not work in the 'Sales' department, you would use the following SQL query: SELECT * FROM Employees WHERE NOT Department = 'Sales'; This query will return all employees whose Department is not 'Sales'. It effectively excludes all 'Sales' department employees ...
Read more

Database Management System

Image
Database Management System Write a query with a function of DDL commands such as create, alter and drop. DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database. DDL is a set of SQL commands used to create, modify, and delete database structures but not data. List of DDL commands: CREATE: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers). QUERY: create table bca2 (stu_name varchar(6), stu_roll int, stu_marks number(7)); OUTPUT: DROP: This command is used to delete objects from the database. QUERY: drop table bca2; OUTPUT: ...
Read more

Create a student table and describe the schema of the student table

Image
Create a student table and describe the schema of the student table Create a student table and describe the schema of the student table: Rollno number(6), Name varchar(15), Dept varchar(10), City varchar(15), DOB date, Gender char(1) QUERY* create table student (Rollno number(6), Name varchar(15), Dept varchar(10), City varchar(15), DOB date, Gender char(1)); Fig. 3.1 Add foreign key constraint for the column rollno from studmarks that refers rollno from student table. QUERY* alter table student add foreign key (Rollno) references stu_marks(Rollno); desc student; Fig. 3.2 Remove the column city from the student table. QUERY* alter table student drop column City; Fig. 3.3 Previous Next
Read more