Skip to main content

 CREATE TABLE employees (emp_id NUMBER PRIMARY KEY, name VARCHAR(20), salary int city VARCHAR(20));


INSERT INTO employees (emp_id, name, salary,city) VALUES (101, INSERT INTO employees (emp_id, name, salary, city) VALUES (102, ABHAY, 55000, GREATER NOIDAL 'Abhishek', 50000, NOIDA)


INSERT INTO employees (emp_id, name, salary, city) VALUES (103, JOHN', 53000, ΕΚΟΣ


INSERT INTO employees (emp_id, name, salary, city) VALUES (104, 'KHUSHI, 550000, GONDA


INSERT INTO employees (emp_id, name, salary,city) VALUES (105, 'AJAY', 500000, DELHI


DESC employees;


INSERT INTO employees (emp_id, name, salary salary, city) VALUES (106, 'KHUSHI' CH', 530000, LUCKNOW


Select from employees;

Comments

Post a Comment

Popular posts from this blog

Here Is The Future Of Bitcion : TechOrbitAI

🌐 Upcoming Bitcoin News and Predictions: What Lies Ahead for the King of Crypto? 🚀 Introduction: The Bitcoin Roller Coaster Bitcoin, the world’s first and most popular cryptocurrency, has continued to evolve from a fringe digital asset to a household name in global finance. As we head deeper into 2025, the anticipation around upcoming Bitcoin news and price predictions is at an all-time high. With increasing institutional interest, regulatory changes, macroeconomic shifts, and technological upgrades, Bitcoin is at a critical juncture. This article explores the most important upcoming developments, expert forecasts, and what they mean for investors, traders, and the global economy. 📊 Bitcoin’s 2024 Recap: Setting the Stage Before diving into the predictions, it's essential to understand the context. 2024 was a pivotal year for Bitcoin: April 2024 Halving Event: Bitcoin underwent its fourth halving, reducing mining rewards from 6.25 to 3.125 BTC. Historically, halving e...
Post a Comment
Read more
 Got it 👍 You want the exact SQL commands that you can type and run in your SQL editor (like Oracle SQL, MySQL, or PostgreSQL). I’ll give you both DDL and DML commands properly written. --- 🔹 Data Definition Language (DDL) 1. Create a table CREATE TABLE employees (     emp_id NUMBER PRIMARY KEY,     name VARCHAR2(50),     salary NUMBER(10, 2),     hire_date DATE ); 2. Alter table 👉 Add a new column: ALTER TABLE employees ADD (department_id NUMBER); 👉 Modify column datatype: ALTER TABLE employees MODIFY (name VARCHAR2(100)); 3. Drop table DROP TABLE employees; 4. Truncate table TRUNCATE TABLE employees; 5. Rename table RENAME employees TO staff; --- 🔹 Data Manipulation Language (DML) 1. Insert data INSERT INTO employees (emp_id, name, salary, hire_date) VALUES (101, 'Alice Johnson', 55000, TO_DATE('2022-01-15', 'YYYY-MM-DD')); 2. Select data SELECT name, salary FROM employees WHERE salary > 50000; 3. Update data UPDATE employees SET sa...
Post a Comment
Read more