SQL Database

Difference between delete drop and truncate – Nicely Explained

Difference between drop, delete and truncate in SQL database is frequently asked interview question. DELETE removes rows one by one depending upon WHERE condition or delete all rows if there is no WHERE condition. TRUNCATE removes all rows at once and DROP command removes a table or database completely from database. In some situations, it […]

Explain Aggregate and Scalar functions in SQL

Answer includes, what is scalar functions in SQL and aggregate functions with examples and difference between scalar and aggregate functions. SQL Scalar functions: SQL scalar functions return a single value, based on the input value. For example, if we have to calculate the length of the string or want to convert letters in upper case or […]

Scroll to top