Anil Singh | Code-sample.com

What is Right Outer Join in SQL? Why you use? In the RIGHT OUTER JOIN , returns all the matched rows from the right table and matched rows from left table. If the left table rows are not matched then return NULL values. I hope you are enjoying with this post! Please share with you friends!! Thank you!!!

ANY keyword is used with a WHERE or HAVING clause. ANY keyword operates on sub-queries that return multiple values. ANY keyword returns true if any sub-query values matched the condition. Syntax: --SELECT TABLE ROWS and Used of ANY Keyword. SELECT Id, Name FROM [dbo].[Tbl_Demo] WHERE Id = ANY ( SELECT Id FROM [dbo].[Tbl_Demo] WHERE Id = 2 ) -- Result looks like, Id Name -------------- 2 Aradhya -- CREATE TABLE CREATE TABLE [dbo].[Tbl_Demo]( [ID] [ int ] IDENTITY( 1 , 1 ) NOT NULL , [Name] [ varchar ]( 500 ) NULL , [Age] [ int ] NULL , [IsActive] [ bit ] NULL , [IsDeleted] [ bit ] NULL , CONSTRAINT [PK_Tbl_Demo] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO --INSERT TABLE ROWS SET IDENTITY_INSERT [dbo].[Tbl_Demo] ON GO INSERT [dbo].[Tbl_Demo] ([I...