nested select sql – A nested SELECT is a query within a query. A Subquery or Inner query or a
Category: Mysql
sql get current year – How to get the Current Year to Current date in sql?
sql get current year — How to get the current date, time, month or year? he YEAR() function returns the
sql not distinct – How to Select Every Row Where Column Value is NOT Distinct?
sql not distinct – In SQL NULL = NULL isn’t true. Unique constraint in SQL is used to check whether
sql count case – sql count(case when multiple criteria)
sql count case – The SQL CASE statement; Adding multiple conditions to a CASE statement; best article fir SQL queries
many to many relationship sql – How to Create a Many-to-Many Relationship?
many to many relationship sql – Many-to-many (M:M) – Many to many includes two dimensions, A many-to-many (or M:N) relationship
left join vs right join – Difference between Left Join and Right Join
As you know join means to join two or more things together. In the case of SQL, join means –
sql check if string contains letters – How To Check If A String Contains A Substring In SQL Server?
sql check if string contains letters – Method 1 – Using CHARINDEX() function, Method 2 – Using LIKE Predicate –
how to remove php extension from url without htaccess?
how to remove php extension from url without htaccess : Change the .html to .php. Remove .php extension from URL.
sql query to sum two columns values based on its record – How to SUM two fields within an SQL query?
sql query to sum two columns values based on its record – The SQL AGGREGATE SUM() function returns the SUM
inner join in php – How to Use Joins in PHP?
inner join in php – A join lets you combine columns from two or more tables into a single result
how to integrate stripe payment gateway in php – stripe php [stripe integration in php]
how to integrate stripe payment gateway in php? – Stripe Manage Subscription Payment using Codeigniter – Recurring payments also known
sql add date – How to Add Days to a Date in SQL?
sql add date – DATEADD(): Functions is used when we want to get date by adding days or month or