How to select top five or 'N' rows in Oracle 11g
Learn how to select top five or 'n' rows in oracle 11g with practical examples, diagrams, and best practices. Covers sql, oracle-database, oracle11g development techniques with visual explanations.
Tag: Sql
How to use parameters with RPostgreSQL (to insert data)
Learn how to use parameters with rpostgresql (to insert data) with practical examples, diagrams, and best practices. Covers sql, r, postgresql development techniques with visual explanations.
How to change a table name using an SQL query?
Learn how to change a table name using an sql query? with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2005 development techniques with visual explanations.
Replace function in SQL
Learn replace function in sql with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
SQL : BETWEEN vs <= and >=
Learn sql : between vs <= and >= with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
Javascript date to sql date object
Learn javascript date to sql date object with practical examples, diagrams, and best practices. Covers javascript, sql, sql-server development techniques with visual explanations.
Categories:
Creating alias in query and using it
Learn creating alias in query and using it with practical examples, diagrams, and best practices. Covers sql, alias development techniques with visual explanations.
How to get a list column names and datatypes of a table in PostgreSQL?
Learn how to get a list column names and datatypes of a table in postgresql? with practical examples, diagrams, and best practices. Covers sql, postgresql, sqldatatypes development techniques with ...
Altering column size in SQL Server
Learn altering column size in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, database development techniques with visual explanations.
How to execute an IN lookup in SQL using Golang?
Learn how to execute an in lookup in sql using golang? with practical examples, diagrams, and best practices. Covers sql, go development techniques with visual explanations.
Oracle SQL Stored Procedures Call vs. Execute
Learn oracle sql stored procedures call vs. execute with practical examples, diagrams, and best practices. Covers sql, oracle-database, stored-procedures development techniques with visual explanat...
SQL Server - Create a copy of a database table and place it in the same database?
Learn sql server - create a copy of a database table and place it in the same database? with practical examples, diagrams, and best practices. Covers sql, sql-server-2008, t-sql development techniq...
How can I tell what edition of SQL Server runs on the machine?
Learn how can i tell what edition of sql server runs on the machine? with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
SQL Server Insert if not exists
Learn sql server insert if not exists with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008 development techniques with visual explanations.
Search text in stored procedure in SQL Server
Learn search text in stored procedure in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, stored-procedures development techniques with visual explanations.
Convert INT to VARCHAR SQL
Learn convert int to varchar sql with practical examples, diagrams, and best practices. Covers sql, select, type-conversion development techniques with visual explanations.
How to compare two SQLite databases on Linux
Learn how to compare two sqlite databases on linux with practical examples, diagrams, and best practices. Covers sql, linux, sqlite development techniques with visual explanations.
NOT IN vs NOT EXISTS
Learn not in vs not exists with practical examples, diagrams, and best practices. Covers sql, sql-server, notin development techniques with visual explanations.
SQL-script: How to write ALTER statements to set Primary key on an existing table?
Learn sql-script: how to write alter statements to set primary key on an existing table? with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008 development t...
What is the difference between JOIN and INNER JOIN?
Learn what is the difference between join and inner join? with practical examples, diagrams, and best practices. Covers sql, sql-server, join development techniques with visual explanations.
How can I do an UPDATE statement with JOIN in SQL Server?
Learn how can i do an update statement with join in sql server? with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
What does the % symbol do at the end of a string in SQL?
Learn what does the % symbol do at the end of a string in sql? with practical examples, diagrams, and best practices. Covers sql, string development techniques with visual explanations.
How to increase the performance of a Database?
Learn how to increase the performance of a database? with practical examples, diagrams, and best practices. Covers sql, database, sql-server-2005 development techniques with visual explanations.
SQL UPDATE WHERE IN (List) or UPDATE each individually?
Learn sql update where in (list) or update each individually? with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
Finding and deleting duplicate values in a SQL table
Learn finding and deleting duplicate values in a sql table with practical examples, diagrams, and best practices. Covers sql, duplicates development techniques with visual explanations.
How can I delete using INNER JOIN with SQL Server?
Learn how can i delete using inner join with sql server? with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008 development techniques with visual explanations.
Delete duplicate rows keeping the first row
Learn delete duplicate rows keeping the first row with practical examples, diagrams, and best practices. Covers sql, sql-server-2008, duplicates development techniques with visual explanations.
Return rows in random order
Learn return rows in random order with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
How do I do multiple CASE WHEN conditions using SQL Server 2008?
Learn how do i do multiple case when conditions using sql server 2008? with practical examples, diagrams, and best practices. Covers sql, sql-server-2008 development techniques with visual explanat...
OPTION (RECOMPILE) is Always Faster; Why?
Learn option (recompile) is always faster; why? with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008 development techniques with visual explanations.
sql query to return differences between two tables
Learn sql query to return differences between two tables with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008 development techniques with visual explanations.
SQL Server POWER function
Learn sql server power function with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008-r2 development techniques with visual explanations.
Join two tables based on relationship defined in third table
Learn join two tables based on relationship defined in third table with practical examples, diagrams, and best practices. Covers sql, join development techniques with visual explanations.
A select query selecting a select statement
Learn a select query selecting a select statement with practical examples, diagrams, and best practices. Covers sql, ms-access, select development techniques with visual explanations.
Trying to count cumulative distinct entities using Redshift SQL
Learn trying to count cumulative distinct entities using redshift sql with practical examples, diagrams, and best practices. Covers sql, amazon-redshift development techniques with visual explanati...
How do I query for all dates greater than a certain date in SQL Server?
Learn how do i query for all dates greater than a certain date in sql server? with practical examples, diagrams, and best practices. Covers sql, sql-server, datetime development techniques with vis...
Use a LIKE clause in part of an INNER JOIN
Learn use a like clause in part of an inner join with practical examples, diagrams, and best practices. Covers sql, sql-server, design-patterns development techniques with visual explanations.
SQL queries inside IN() clause
Learn sql queries inside in() clause with practical examples, diagrams, and best practices. Covers sql, in-clause development techniques with visual explanations.
SQL query to select dates between two dates
Learn sql query to select dates between two dates with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
SQL Server IF NOT EXISTS Usage?
Learn sql server if not exists usage? with practical examples, diagrams, and best practices. Covers sql, sql-server, stored-procedures development techniques with visual explanations.
SQL Server Cast and Rounding
Learn sql server cast and rounding with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
Insert Data Into Temp Table with Query
Learn insert data into temp table with query with practical examples, diagrams, and best practices. Covers sql, sql-server, ssms development techniques with visual explanations.
How does database indexing work?
Learn how does database indexing work? with practical examples, diagrams, and best practices. Covers sql, database, performance development techniques with visual explanations.
SQL Query for three tables with calculation
Learn sql query for three tables with calculation with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
Last 3 Months Where Statement
Learn last 3 months where statement with practical examples, diagrams, and best practices. Covers sql, sql-server, where-clause development techniques with visual explanations.
Selecting COUNT(*) with DISTINCT
Learn selecting count(*) with distinct with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
JOIN three tables
Learn join three tables with practical examples, diagrams, and best practices. Covers sql, mysql, database development techniques with visual explanations.
Joining multiple tables in SQL
Learn joining multiple tables in sql with practical examples, diagrams, and best practices. Covers sql, sql-server, join development techniques with visual explanations.
SQL days since DATEDIFF()
Learn sql days since datediff() with practical examples, diagrams, and best practices. Covers sql, datediff development techniques with visual explanations.
Create a stored procedure to insert new data into a table
Learn create a stored procedure to insert new data into a table with practical examples, diagrams, and best practices. Covers sql, sql-server, stored-procedures development techniques with visual e...
how to execute SQL statements in command prompt (CMD)
Learn how to execute sql statements in command prompt (cmd) with practical examples, diagrams, and best practices. Covers sql, sql-server, cmd development techniques with visual explanations.
GROUP BY without aggregate function
Learn group by without aggregate function with practical examples, diagrams, and best practices. Covers sql, group-by, aggregate-functions development techniques with visual explanations.
Inserting data into a temporary table
Learn inserting data into a temporary table with practical examples, diagrams, and best practices. Covers sql, sql-server, temp-tables development techniques with visual explanations.
FULL OUTER JOIN vs. FULL JOIN
Learn full outer join vs. full join with practical examples, diagrams, and best practices. Covers sql, sql-server-2008, t-sql development techniques with visual explanations.
Need some help understanding IO Statistics
Learn need some help understanding io statistics with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2005 development techniques with visual explanations.
Benefits of Index Scan over Table Scan in simple words?
Learn benefits of index scan over table scan in simple words? with practical examples, diagrams, and best practices. Covers sql, sql-server-2008-r2 development techniques with visual explanations.
postgresql: INSERT INTO ... (SELECT * ...)
Learn postgresql: insert into ... (select * ...) with practical examples, diagrams, and best practices. Covers sql, postgresql, insert development techniques with visual explanations.
SQL update query using joins
Learn sql update query using joins with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
SQL: JOIN vs LEFT OUTER JOIN?
Learn sql: join vs left outer join? with practical examples, diagrams, and best practices. Covers sql, join, left-join development techniques with visual explanations.
Best way to do nested case statement logic in SQL Server
Learn best way to do nested case statement logic in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2005 development techniques with visual expl...
SQL WHERE ID IN (id1, id2, ..., idn)
Learn sql where id in (id1, id2, ..., idn) with practical examples, diagrams, and best practices. Covers sql, select development techniques with visual explanations.
Get week day name from a given month, day and year individually in SQL Server
Learn get week day name from a given month, day and year individually in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, function development techniques wi...
How do I perform an IF...THEN in an SQL SELECT?
Learn how do i perform an if...then in an sql select? with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
Update multiple columns in SQL
Learn update multiple columns in sql with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-update development techniques with visual explanations.
Does SQL have a list type that can be used in a WHERE ... IN clause?
Learn does sql have a list type that can be used in a where ... in clause? with practical examples, diagrams, and best practices. Covers sql, t-sql development techniques with visual explanations.
How do I use ROW_NUMBER()?
Learn how do i use row_number()? with practical examples, diagrams, and best practices. Covers sql, sql-server, row-number development techniques with visual explanations.
Inserting multiple rows in a single SQL query?
Learn inserting multiple rows in a single sql query? with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
SQL query with NOT LIKE IN
Learn sql query with not like in with practical examples, diagrams, and best practices. Covers sql, sql-server-2008, t-sql development techniques with visual explanations.
SELECT query with CASE condition and SUM()
Learn select query with case condition and sum() with practical examples, diagrams, and best practices. Covers sql, sql-server, sum development techniques with visual explanations.
Function vs. Stored Procedure in SQL Server
Learn function vs. stored procedure in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
Meaning of sp_who Status in SQL Server
Learn meaning of sp_who status in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
What's the difference between RANK() and DENSE_RANK() functions in oracle?
Learn what's the difference between rank() and dense_rank() functions in oracle? with practical examples, diagrams, and best practices. Covers sql, oracle-database, window-functions development tec...
What is "Connect Timeout" in sql server connection string?
Learn what is "connect timeout" in sql server connection string? with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
Difference between INT PRIMARY KEY and INTEGER PRIMARY KEY SQLite
Learn difference between int primary key and integer primary key sqlite with practical examples, diagrams, and best practices. Covers sql, sqlite development techniques with visual explanations.
Use tnsnames.ora in Oracle SQL Developer
Learn use tnsnames.ora in oracle sql developer with practical examples, diagrams, and best practices. Covers sql, oracle-database, tnsnames development techniques with visual explanations.
Adding table to existing database in SQL
Learn adding table to existing database in sql with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
sql query "WHERE IN"
Learn sql query "where in" with practical examples, diagrams, and best practices. Covers sql, where-clause development techniques with visual explanations.
How do I loop through a set of records in SQL Server?
Learn how do i loop through a set of records in sql server? with practical examples, diagrams, and best practices. Covers sql, sql-server, loops development techniques with visual explanations.
Get list of all tables in Oracle?
Learn get list of all tables in oracle? with practical examples, diagrams, and best practices. Covers sql, oracle-database development techniques with visual explanations.
Using a SQL Server for application logging. Pros/Cons?
Learn using a sql server for application logging. pros/cons? with practical examples, diagrams, and best practices. Covers sql, logging, text-files development techniques with visual explanations.
Convert a string to int using sql query
Learn convert a string to int using sql query with practical examples, diagrams, and best practices. Covers sql, sql-server-2005 development techniques with visual explanations.
SQL Delete Records within a specific Range
Learn sql delete records within a specific range with practical examples, diagrams, and best practices. Covers sql, sql-delete, records development techniques with visual explanations.
How can I list the tables in a SQLite database file that was opened with ATTACH?
Learn how can i list the tables in a sqlite database file that was opened with attach? with practical examples, diagrams, and best practices. Covers sql, sqlite, database-schema development techniq...
How to return only the Date from a SQL Server DateTime datatype
Learn how to return only the date from a sql server datetime datatype with practical examples, diagrams, and best practices. Covers sql, date, t-sql development techniques with visual explanations.
How to create timestamp column with default value 'now'?
Learn how to create timestamp column with default value 'now'? with practical examples, diagrams, and best practices. Covers sql, sqlite development techniques with visual explanations.
Using group by on multiple columns
Learn using group by on multiple columns with practical examples, diagrams, and best practices. Covers sql, group-by, multiple-columns development techniques with visual explanations.
Counter variable in SQLite
Learn counter variable in sqlite with practical examples, diagrams, and best practices. Covers sql, actionscript-3, sqlite development techniques with visual explanations.
How to use GROUP BY on a CLOB column with Oracle?
Learn how to use group by on a clob column with oracle? with practical examples, diagrams, and best practices. Covers sql, oracle-database, group-by development techniques with visual explanations.
How to check if a stored procedure exists before creating it
Learn how to check if a stored procedure exists before creating it with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
Which column for foreign key: id or any other column and why?
Learn which column for foreign key: id or any other column and why? with practical examples, diagrams, and best practices. Covers sql, postgresql, foreign-keys development techniques with visual ex...
SQL multiple column ordering
Learn sql multiple column ordering with practical examples, diagrams, and best practices. Covers sql, sorting, sql-order-by development techniques with visual explanations.
LEFT function in Oracle
Learn left function in oracle with practical examples, diagrams, and best practices. Covers sql, oracle-database development techniques with visual explanations.
How to delete specific rows in a sql table
Learn how to delete specific rows in a sql table with practical examples, diagrams, and best practices. Covers sql, sql-delete development techniques with visual explanations.
Change Date Format(DD/MM/YYYY) in SQL SELECT Statement
Learn change date format(dd/mm/yyyy) in sql select statement with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
Create a pivot table with PostgreSQL
Learn create a pivot table with postgresql with practical examples, diagrams, and best practices. Covers sql, postgresql, pivot-table development techniques with visual explanations.
Multiple separate IF conditions in SQL Server
Learn multiple separate if conditions in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, if-statement development techniques with visual explanations.
How can I get column names from a table in SQL Server?
Learn how can i get column names from a table in sql server? with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008 development techniques with visual explan...
SQL COMMANDS to add a new column
Learn sql commands to add a new column with practical examples, diagrams, and best practices. Covers sql, sql-server, concatenation development techniques with visual explanations.
What is the difference between INNER JOIN and OUTER JOIN?
Learn what is the difference between inner join and outer join? with practical examples, diagrams, and best practices. Covers sql, join, inner-join development techniques with visual explanations.
How do I UPDATE from a SELECT in SQL Server?
Learn how do i update from a select in sql server? with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
INNER JOIN vs INNER JOIN (SELECT . FROM)
Learn inner join vs inner join (select . from) with practical examples, diagrams, and best practices. Covers sql, sql-server, join development techniques with visual explanations.
When should I use CROSS APPLY over INNER JOIN?
Learn when should i use cross apply over inner join? with practical examples, diagrams, and best practices. Covers sql, sql-server, performance development techniques with visual explanations.
Find all tables containing column with specified name
Learn find all tables containing column with specified name with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
sp_MSforeachdb: only include results from databases with results
Learn sp_msforeachdb: only include results from databases with results with practical examples, diagrams, and best practices. Covers sql, sql-server-2008, stored-procedures development techniques w...
SQL Server - Using ROW_NUMBER() OVER PARTITION function to SET a value
Learn sql server - using row_number() over partition function to set a value with practical examples, diagrams, and best practices. Covers sql, sql-server, row-number development techniques with vi...
SQL query to find third highest salary in company
Learn sql query to find third highest salary in company with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
Month difference between two dates in sql server
Learn month difference between two dates in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
SQL 'LIKE' query using '%' where the search criteria contains '%'
Learn sql 'like' query using '%' where the search criteria contains '%' with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-like development techniques with visual ex...
SQL How to insert a new row in the middle of the table
Learn sql how to insert a new row in the middle of the table with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
SQL Relational Algebra Query
Learn sql relational algebra query with practical examples, diagrams, and best practices. Covers sql, relational-algebra development techniques with visual explanations.
Add a row number to result set of a SQL query
Learn add a row number to result set of a sql query with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2005 development techniques with visual explanations.
How to drop all NOT NULL constraints from a PostgreSQL table in one go
Learn how to drop all not null constraints from a postgresql table in one go with practical examples, diagrams, and best practices. Covers sql, postgresql, constraints development techniques with v...
Custom Date/Time formatting in SQL Server
Learn custom date/time formatting in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, datetime development techniques with visual explanations.
SQL CASE WHEN with multiple AND and OR
Learn sql case when with multiple and and or with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
When is a good situation to use a full outer join?
Learn when is a good situation to use a full outer join? with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
Understanding union query
Learn understanding union query with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
Syntax of for-loop in SQL Server
Learn syntax of for-loop in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, loops development techniques with visual explanations.
Is there a combination of "LIKE" and "IN" in SQL?
Learn is there a combination of "like" and "in" in sql? with practical examples, diagrams, and best practices. Covers sql, sql-server, oracle-database development techniques with visual explanations.
How to export all data from table to an insertable sql format?
Learn how to export all data from table to an insertable sql format? with practical examples, diagrams, and best practices. Covers sql, sql-server, copy development techniques with visual explanati...
How to drop all tables from a database with one SQL query?
Learn how to drop all tables from a database with one sql query? with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
SQL Server Creating Index over Index
Learn sql server creating index over index with practical examples, diagrams, and best practices. Covers sql, sql-server-2008, indexing development techniques with visual explanations.
What are cons and pros a of defining a constraint deferrable
Learn what are cons and pros a of defining a constraint deferrable with practical examples, diagrams, and best practices. Covers sql, oracle-database, database-design development techniques with vi...
PostgreSQL IF statement
Learn postgresql if statement with practical examples, diagrams, and best practices. Covers sql, postgresql, if-statement development techniques with visual explanations.
How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?
Learn how do i cast a string to integer and have 0 in case of error in the cast with postgresql? with practical examples, diagrams, and best practices. Covers sql, postgresql, casting development t...
What are DDL and DML?
Learn what are ddl and dml? with practical examples, diagrams, and best practices. Covers sql, ddl, dml development techniques with visual explanations.
Use string contains function in oracle SQL query
Learn use string contains function in oracle sql query with practical examples, diagrams, and best practices. Covers sql, oracle-database development techniques with visual explanations.
Database design for database-agnostic applications
Learn database design for database-agnostic applications with practical examples, diagrams, and best practices. Covers sql, database, database-design development techniques with visual explanations.
Convert String to Date SQL
Learn convert string to date sql with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
How can I define a composite primary key in SQL?
Learn how can i define a composite primary key in sql? with practical examples, diagrams, and best practices. Covers sql, primary-key, composite-primary-key development techniques with visual expla...
What does the slash mean in an SQL query?
Learn what does the slash mean in an sql query? with practical examples, diagrams, and best practices. Covers sql, mysql development techniques with visual explanations.
Postgres syntax error at or near "IF"
Learn postgres syntax error at or near "if" with practical examples, diagrams, and best practices. Covers sql, postgresql, if-statement development techniques with visual explanations.
SQL Server : Transpose rows to columns
Learn sql server : transpose rows to columns with practical examples, diagrams, and best practices. Covers sql, t-sql, sql-server-2005 development techniques with visual explanations.
MySQL LIKE IN()?
Learn mysql like in()? with practical examples, diagrams, and best practices. Covers sql, mysql development techniques with visual explanations.
SQL Update from One Table to Another Based on a ID Match
Learn sql update from one table to another based on a id match with practical examples, diagrams, and best practices. Covers sql, sql-server, select development techniques with visual explanations.
Stored Procedure error ORA-06550
Learn stored procedure error ora-06550 with practical examples, diagrams, and best practices. Covers sql, oracle-database, stored-procedures development techniques with visual explanations.
How to create Temp table with SELECT * INTO tempTable FROM CTE Query
Learn how to create temp table with select * into temptable from cte query with practical examples, diagrams, and best practices. Covers sql, sql-server, common-table-expression development techniq...
ORA-29273: HTTP request failed intermittent error using the utl_http package
Learn ora-29273: http request failed intermittent error using the utl_http package with practical examples, diagrams, and best practices. Covers sql, oracle-database, plsql development techniques w...
Insert into ... values ( SELECT ... FROM ... )
Learn insert into ... values ( select ... from ... ) with practical examples, diagrams, and best practices. Covers sql, database, syntax development techniques with visual explanations.
SQL select statements with multiple tables
Learn sql select statements with multiple tables with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
SQL Server: how to find closest location?
Learn sql server: how to find closest location? with practical examples, diagrams, and best practices. Covers sql, sql-server-2008, geo development techniques with visual explanations.
SQL SELECT WHERE field contains words
Learn sql select where field contains words with practical examples, diagrams, and best practices. Covers sql, select, contains development techniques with visual explanations.
How to concatenate in SQL Server
Learn how to concatenate in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
Foreign keys vs secondary keys
Learn foreign keys vs secondary keys with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
Is there a coalesce-like function in Excel?
Learn is there a coalesce-like function in excel? with practical examples, diagrams, and best practices. Covers sql, excel, xls development techniques with visual explanations.
What is the string concatenation operator in Oracle?
Learn what is the string concatenation operator in oracle? with practical examples, diagrams, and best practices. Covers sql, oracle-database, plsql development techniques with visual explanations.
query for substring formation
Learn query for substring formation with practical examples, diagrams, and best practices. Covers sql, database, string development techniques with visual explanations.
Using If else in SQL Select statement
Learn using if else in sql select statement with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
Could not update the metadata that indicates database X is enabled for Change Data Capture. The e...
Learn could not update the metadata that indicates database x is enabled for change data capture. the error returned was 15517 with practical examples, diagrams, and best practices. Covers sql, sql...
How can i update(increase one) int value by using sql command?
Learn how can i update(increase one) int value by using sql command? with practical examples, diagrams, and best practices. Covers asp.net, sql development techniques with visual explanations.
PL/SQL mysterious arrow operator
Learn pl/sql mysterious arrow operator with practical examples, diagrams, and best practices. Covers sql, oracle-database, operators development techniques with visual explanations.
SQL query with comments import into R from file
Learn sql query with comments import into r from file with practical examples, diagrams, and best practices. Covers sql, r development techniques with visual explanations.
Get day of week in SQL Server 2005/2008
Learn get day of week in sql server 2005/2008 with practical examples, diagrams, and best practices. Covers sql, sql-server, datetime development techniques with visual explanations.
Create new user in MySQL and give it full access to one database
Learn create new user in mysql and give it full access to one database with practical examples, diagrams, and best practices. Covers sql, mysql, database development techniques with visual explanat...
Any downsides of using data type "text" for storing strings?
Learn any downsides of using data type "text" for storing strings? with practical examples, diagrams, and best practices. Covers sql, postgresql, types development techniques with visual explanations.
SQL Server Insert Example
Learn sql server insert example with practical examples, diagrams, and best practices. Covers sql, sql-server, database development techniques with visual explanations.
How to check if a table exists in a given schema
Learn how to check if a table exists in a given schema with practical examples, diagrams, and best practices. Covers sql, database, postgresql development techniques with visual explanations.
SQL: How to insert data into a table with column names
Learn sql: how to insert data into a table with column names with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanations.
CASE .. WHEN expression in Oracle SQL
Learn case .. when expression in oracle sql with practical examples, diagrams, and best practices. Covers sql, oracle-database, oracle10g development techniques with visual explanations.
Incorrect Syntax near keyword 'Transaction' SQL Insertion Statements
Learn incorrect syntax near keyword 'transaction' sql insertion statements with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual explanati...
count distinct records (all columns) not working
Learn count distinct records (all columns) not working with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
How to put NO LOCK for stored procedure T-SQL for all tables
Learn how to put no lock for stored procedure t-sql for all tables with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.
When would I use XML instead of SQL?
Learn when would i use xml instead of sql? with practical examples, diagrams, and best practices. Covers sql, xml development techniques with visual explanations.
Is it possible to apply SELECT INTO a temporary table from another SELECT?
Learn is it possible to apply select into a temporary table from another select? with practical examples, diagrams, and best practices. Covers sql, sql-server development techniques with visual exp...
SQL Inserting multiples values using the result of a select
Learn sql inserting multiples values using the result of a select with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
select from one table, insert into another table oracle sql query
Learn select from one table, insert into another table oracle sql query with practical examples, diagrams, and best practices. Covers sql, oracle-database, select development techniques with visual...
SQL Switch/Case in 'where' clause
Learn sql switch/case in 'where' clause with practical examples, diagrams, and best practices. Covers sql, switch-statement, case development techniques with visual explanations.
Difference between CASCADE and RESTRICT? SQL DDL database
Learn difference between cascade and restrict? sql ddl database with practical examples, diagrams, and best practices. Covers sql, database, ddl development techniques with visual explanations.
Altering SQL table to add column
Learn altering sql table to add column with practical examples, diagrams, and best practices. Covers sql, sql-server, database development techniques with visual explanations.
Combining "LIKE" and "IN" for SQL Server
Learn combining "like" and "in" for sql server with practical examples, diagrams, and best practices. Covers sql, sql-like development techniques with visual explanations.
CONCAT equivalent in MS Access
Learn concat equivalent in ms access with practical examples, diagrams, and best practices. Covers sql, ms-access, ms-access-2010 development techniques with visual explanations.
Convert Rows to columns using 'Pivot' in SQL Server
Learn convert rows to columns using 'pivot' in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, pivot development techniques with visual explanations.
SQL WITH clause example
Learn sql with clause example with practical examples, diagrams, and best practices. Covers sql, with-clause development techniques with visual explanations.
What is a "Scalar" Query?
Learn what is a "scalar" query? with practical examples, diagrams, and best practices. Covers sql, database, executescalar development techniques with visual explanations.
How does Subquery in select statement work in oracle
Learn how does subquery in select statement work in oracle with practical examples, diagrams, and best practices. Covers sql, oracle-database, select development techniques with visual explanations.
Difference between DECLARE and SET in SQL
Learn difference between declare and set in sql with practical examples, diagrams, and best practices. Covers mysql, sql, set development techniques with visual explanations.
What do the “l” and “p” mean in this SQL statement?
Learn what do the “l” and “p” mean in this sql statement? with practical examples, diagrams, and best practices. Covers mysql, sql, phpmyadmin development techniques with visual explanations.
What are differences between INSERT and UPDATE in MySQL?
Learn what are differences between insert and update in mysql? with practical examples, diagrams, and best practices. Covers mysql, sql, sql-update development techniques with visual explanations.
MySQL SELECT only not null values
Learn mysql select only not null values with practical examples, diagrams, and best practices. Covers mysql, sql, select development techniques with visual explanations.
What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
Learn what's the difference between inner join, left join, right join and full join? with practical examples, diagrams, and best practices. Covers mysql, sql, join development techniques with visua...
What is the proper syntax for LIKE?
Learn what is the proper syntax for like? with practical examples, diagrams, and best practices. Covers mysql, sql development techniques with visual explanations.
Now() vs GetDate()
Learn now() vs getdate() with practical examples, diagrams, and best practices. Covers mysql, sql, sql-server development techniques with visual explanations.
mysql world database: select country with max population
Learn mysql world database: select country with max population with practical examples, diagrams, and best practices. Covers mysql, sql development techniques with visual explanations.
Dynamically structured mySQL database for an Airline Reservation App
Learn dynamically structured mysql database for an airline reservation app with practical examples, diagrams, and best practices. Covers mysql, sql, database development techniques with visual expl...
MySQL Timestamp format
Learn mysql timestamp format with practical examples, diagrams, and best practices. Covers mysql, sql, date development techniques with visual explanations.
Integer values for status fields
Learn integer values for status fields with practical examples, diagrams, and best practices. Covers mysql, sql, database-design development techniques with visual explanations.
How to create a MySQL hierarchical recursive query?
Learn how to create a mysql hierarchical recursive query? with practical examples, diagrams, and best practices. Covers mysql, sql, hierarchical-data development techniques with visual explanations.
Can a table have multiple Primary keys?
Learn can a table have multiple primary keys? with practical examples, diagrams, and best practices. Covers mysql, sql, sql-server development techniques with visual explanations.
Using an Alias in SQL Calculations
Learn using an alias in sql calculations with practical examples, diagrams, and best practices. Covers mysql, sql, database development techniques with visual explanations.
[Microsoft][ODBC Driver Manager] Invalid string or buffer length exception
Learn [microsoft][odbc driver manager] invalid string or buffer length exception with practical examples, diagrams, and best practices. Covers java, sql, sql-server development techniques with visu...
Categories:
could not extract ResultSet in hibernate
Learn could not extract resultset in hibernate with practical examples, diagrams, and best practices. Covers java, sql, hibernate development techniques with visual explanations.
Categories:
what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why t...
Learn what is the use of annotations @id and @generatedvalue(strategy = generationtype.identity)? why the generationtype is identity? with practical examples, diagrams, and best practices. Covers j...
Categories:
Returning only the column names from a SELECT statement
Learn returning only the column names from a select statement with practical examples, diagrams, and best practices. Covers c#, asp.net, sql development techniques with visual explanations.
Categories:
What does "WHERE x = ?" mean in SQL
Learn what does "where x = ?" mean in sql with practical examples, diagrams, and best practices. Covers c#, sql development techniques with visual explanations.
Categories:
Sql connection-string for localhost server
Learn sql connection-string for localhost server with practical examples, diagrams, and best practices. Covers c#, sql, sql-server-2008-express development techniques with visual explanations.
Categories:
What does DESC do in SQL?
Learn what does desc do in sql? with practical examples, diagrams, and best practices. Covers php, sql development techniques with visual explanations.
Categories:
Trying to check if username already exists in MySQL database using PHP
Learn trying to check if username already exists in mysql database using php with practical examples, diagrams, and best practices. Covers php, mysql, sql development techniques with visual explana...
Categories:
How to send data updates to a hosted MySQL database remotely over the internet?
Learn how to send data updates to a hosted mysql database remotely over the internet? with practical examples, diagrams, and best practices. Covers php, mysql, sql development techniques with visua...