My Blog

Author: Awais Farooq

  • DELETE VIEW

    —

    by

    Awais Farooq
    in

    Before knowing about what is SQL delete view, it is important to know – What is SQL view? A view is a result set of a stored query on the data. The SQL view is a table which does not physically exist. It is only a virtual table. SQL VIEW can be created by a…

  • DELETE DATABASE

    —

    by

    Awais Farooq
    in

    You can easily remove or delete indexes, tables and databases with the DROP statement. The DROP index statement is: Used to delete index in the table DROP INDEX SYNTAX for MS Access: DROP INDEX SYNTAX for MS SQL Server: DROP INDEX syntax for DB2/Oracle: DROP INDEX syntax for MySQL: DROP DATABASE Statement: The drop database…

  • DELETE DUPLICATE ROWS

    —

    by

    Awais Farooq
    in

    If you have got a situation that you have multiple duplicate records in a table, so at the time of fetching records from the table you should be more careful. You make sure that you are fetching unique records instead of fetching duplicate records. To overcome with this problem we use DISTINCT keyword. It is…

  • DELETE ALL ROWS

    —

    by

    Awais Farooq
    in

    The statement SQL DELETE ALL ROWS is used to delete all rows from the table. If you want to delete all the rows from student table the query would be like, Resulting table after using this query: ID STUDENT_NAME ADDRESS

  • DELETE ROW

    —

    by

    Awais Farooq
    in

    Let us take an example of student. Original table: ID STUDENT _NAME ADDRESS 001 AJEET MAURYA GHAZIABAD 002 RAJA KHAN LUCKNOW 003 RAVI MALIK DELHI If you want to delete a student with id 003 from the student_name table, then the SQL DELETE query should be like this: Resulting table after SQL DELETE query: ID…

  • DELETE TABLE

    —

    by

    Awais Farooq
    in

    The DELETE statement is used to delete rows from a table. If you want to remove a specific row from a table you should use WHERE condition. But if you do not specify the WHERE condition it will remove all the rows from the table. There are some more terms similar to DELETE statement like…

  • DELETE

    —

    by

    Awais Farooq
    in

    The SQL DELETE statement is used to delete rows from a table. Generally DELETE statement removes one or more records from a table. SQL DELETE Syntax Let’s see the Syntax for the SQL DELETE statement: Here table_name is the table which has to be deleted. The WHERE clause in SQL DELETE statement is optional here. SQL DELETE Example Let…

  • UPDATE DATE

    —

    by

    Awais Farooq
    in

    How to update a date and time field in SQL? If you want to update a date & time field in SQL, you should use the following query. let’s see the syntax of sql update date. Let us check this by an example: Firstly we take a table in which we want to update date…

  • UPDATE with JOIN

    —

    by

    Awais Farooq
    in

    SQL UPDATE JOIN means we will update one table using another table and join condition. Let us take an example of a customer table. I have updated customer table that contains latest customer details from another source system. I want to update the customer table with latest data. In such case, I will perform join between…

  • SQL UPDATE

    —

    by

    Awais Farooq
    in

    The SQL commands (UPDATE and DELETE) are used to modify the data that is already in the database. The SQL DELETE command uses a WHERE clause. SQL UPDATE statement is used to change the data of the records held by tables. Which rows is to be update, it is decided by a condition. To specify condition, we use…