Sql

Learn how to calculate age (in years) based on date of birth and getdate() with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual ex...

Learn efficiently convert rows to columns with practical examples, diagrams, and best practices. Covers sql, sql-server, sql-server-2008 development techniques with visual explanations.

Learn nesting queries in sql with practical examples, diagrams, and best practices. Covers sql, nested development techniques with visual explanations.

Learn query comparing dates in sql with practical examples, diagrams, and best practices. Covers sql, sql-server, date development techniques with visual explanations.

Learn combining "like" and "in" for sql server with practical examples, diagrams, and best practices. Covers sql, sql-like development techniques with visual explanations.

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.

Learn what is the difference between views and materialized views in oracle? with practical examples, diagrams, and best practices. Covers sql, oracle-database, view development techniques with vis...

Learn how to use charindex for one or the other character with practical examples, diagrams, and best practices. Covers sql, sql-server, string development techniques with visual explanations.

Learn sql case when in (select...) then with practical examples, diagrams, and best practices. Covers sql, case, databricks development techniques with visual explanations.

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.

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.

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.

Learn replace function in sql with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.

Learn sql : between vs <= and >= with practical examples, diagrams, and best practices. Covers sql, sql-server, t-sql development techniques with visual explanations.

Learn creating alias in query and using it with practical examples, diagrams, and best practices. Covers sql, alias development techniques with visual explanations.

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 ...

Learn altering column size in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, database development techniques with visual explanations.

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.

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...

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...

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.

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.

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.

Learn convert int to varchar sql with practical examples, diagrams, and best practices. Covers sql, select, type-conversion development techniques with visual explanations.

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.

Learn not in vs not exists with practical examples, diagrams, and best practices. Covers sql, sql-server, notin development techniques with visual explanations.

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...

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.

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.

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.