I recently faced an interesting issue when trying to fetch data from third-party API. When trying to connect to the API endpoint, I received the
Tag: SQL
How to use Variable in MySQL Like Clause ?
Here is an example to use SQL variable in the mysql select query like clause SET @name = ‘advancewebsoftware’; SELECT * from `user` WHERE name
SQL : Paging in Stored Procedure
Create simple Student table using following script CREATE TABLE [dbo].[Student]( [ID] [int] NOT NULL, [Name] [varchar](50) NOT NULL) ON [PRIMARY]GO The OFFSET-FETCH clause is used
Function to find dates in current week in mysql
MySQL YEARWEEK() returns year and week number for a given date. Syntax: YEARWEEK(date_value,Mode) Parameters or Arguments date_value A date or datetime value from which to extract
SQL: Condition in Count()
Condition in count() SELECT count(case when EventTypeID =1 then 1 else null end) as TotalTournamentsAttended, count(case when EventTypeID =2 then 1 else null end) as
Difference Between Primary Key and Unique Key
PRIMARY KEY UNIQUE KEY NULL It doesn’t allow Null values. Because of this we refer PRIMARY KEY = UNIQUE KEY + Not Null CONSTRAINT Allows
