Skip to content

Tag Archives: DBMS-SQL

Prerequisites : Basics of SQL   In nested queries, a query is written inside a query. The result of inner query is used in execution… Read More
Structured Query Language is a standard Database language which is used to create, maintain and retrieve the relational database. Following are some interesting facts about… Read More
Consider below simple table:  Name Salary --------------- abc 100000 bcd 1000000 efg 40000 ghi 500000 How to find the employee whose salary is second highest.… Read More
The difference between the having and where clause in SQL is that the where clause cannot be used with aggregates, but the having clause can. The… Read More
An SQL Join is used to combine data from two or more tables based on a common field between them. For example, consider the following… Read More
Which of the following command is used to delete a table in SQL? (A) delete (B) truncate (C) remove (D) drop Answer: (D) Explanation: drop… Read More
The statement that is executed automatically by the system as a side effect of the modification of the database is (A) backup (B) assertion (C)… Read More

Start Your Coding Journey Now!