sql

Topic Replies Views Activity
When do we use on delete set null and on delete cascade?
Data Science/ Machine Learning
sql ,  set
2 118 12 August 2021
What does the select statement do in SQL?
Data Science/ Machine Learning
sql ,  statements
2 137 12 August 2021
SQL commands like DDL, DML, what commands do
Data Science/ Machine Learning
sql ,  commands
2 135 12 August 2021
CRUD Operation
Data Science/ Machine Learning
sql ,  crud
2 130 11 August 2021
Returns nothing. why?
Data Science/ Machine Learning
sql ,  data-wrangling
1 78 11 August 2021
What are the Data types in SQL?
Data Science/ Machine Learning
sql
2 125 30 July 2021
Difference between truncate and drop
Data Science/ Machine Learning
sql ,  statements
3 144 28 July 2021
Difference between primary key and foreign key
Data Science/ Machine Learning
sql ,  key
2 117 28 July 2021
How to join columns of 3 different Tables?
Data Science/ Machine Learning
join ,  sql ,  data-science
2 125 27 August 2020
Group BY and MERGE operation
Data Science/ Machine Learning
sql
2 158 25 August 2020
Questions on JDBC
Data Science/ Machine Learning
sql
1 149 24 August 2020
Which is the toughest query you have written until now?
Data Science/ Machine Learning
sql
1 136 24 August 2020
How to insert an index?
Data Science/ Machine Learning
sql ,  index
1 127 12 August 2020
What is the window function?
Data Science/ Machine Learning
sql ,  function
1 121 12 August 2020
How do you perform joins?
Data Science/ Machine Learning
sql ,  join
1 139 12 August 2020
Discussion on distinct keyword
Data Science/ Machine Learning
sql
1 126 12 August 2020
Explain normalization with example (1NF, 2NF, 3NF)
Data Science/ Machine Learning
sql
1 295 12 August 2020
Write a query to obtain the third-highest salary of the employee
Data Science/ Machine Learning
sql
1 124 12 August 2020
What is the difference between the materialized view and normal view?
Data Science/ Machine Learning
sql
1 118 12 August 2020
What are the some basics function in SQL?
Data Science/ Machine Learning
sql ,  function
1 123 12 August 2020
Difference between where and having clause. When do we use where function and when do we use having a function
Data Science/ Machine Learning
sql ,  function
1 137 12 August 2020
What does union and union all do in SQL?
Data Science/ Machine Learning
sql ,  union
1 126 12 August 2020
Wildcards in SQL
Data Science/ Machine Learning
sql
1 117 12 August 2020
How do we filter data in SQL?
Data Science/ Machine Learning
sql ,  filter
1 117 12 August 2020
How do we create a table in SQL and how do we insert values in those tables?
Data Science/ Machine Learning
sql
1 109 12 August 2020
What do queries mean in SQL?
Data Science/ Machine Learning
sql ,  query
1 117 12 August 2020
Explain joins
Data Science/ Machine Learning
sql ,  join
1 131 12 August 2020
Explain subqueries
Data Science/ Machine Learning
sql ,  subqueries
1 122 12 August 2020
There are 2 tables. One table has missing values in columns. So how do you perform join operation between those 2 tables?
Data Science/ Machine Learning
sql
1 133 12 August 2020