Group by.....Having Clause
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns.
The syntax...
2010-01-31
2,549 reads
Vivek's SQL Notes
Difference Between Having and Where Clause in Sql Server
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there...
2010-01-31
11,960 reads
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a...
2010-01-31
4,042 reads
Sql Server View
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It...
2010-01-31
1,723 reads
Second Normal Form (2NF)
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following...
2010-01-26
3,657 reads
Third Normal Form (3NF)
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy the...
2010-01-26
2,241 reads
First Normal form (INF)
First Normal Form (INF):- A table is said to be in a First Normal Form (1NF)if it satisfy the following...
2010-01-26
794 reads
Database Normalization
Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the...
2010-01-26
2,809 reads
Indexes in Sql server
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval...
2010-01-03
948 reads
Difference between Clustered Index and Non clustered Index
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval...
2010-01-03
783 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers