Here are the top SQL queries how used to know index size. Explained views to refer to as a user /or as a DBA.
Category: SQL
Explained how to create a table from an existing table in oracle. Two queries creating structure only and table with data you will find here.
Here are the top 3 approaches you can try in MySQL and other databases to delete table.
Indexes in the database speed up the pulling of rows. Here are the top rules for when to create and when not to create.
Here’s a way to write an SQL query over partition by limiting rows in Oracle
Explained how to get records using COUNT and COUNT Distinct with Group By clause in SQL
SQL AND and OR logical operators how to use in WHERE clause explained with examples.
You can find duplicate rows using the SQL having clause; the example shows how to use it.
The SQL LIKE command’s output differs when you use it on CHAR and VARCHAR. Here is a post with an example.
These two ways limit the number of rows return from an SQL query. These are helpful for Oracle and other SQL developers.
Here are SQL queries to insert single and multiple rows into a table. Helpful for SQL developers.
Explained SQL queries and syntax to drop a table or modify a table. And added SQL queries helpful to rename a table and truncate a table here.
You must be logged in to post a comment.