tag:blogger.com,1999:blog-7805972021499203804.post897548447661720120..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: Joins in sql server, Inner Join,Cross Join,Left Outer Join,Equi join, Right Outer Join, Full Outer JoinSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger72125tag:blogger.com,1999:blog-7805972021499203804.post-22305498291610610232016-07-26T01:01:08.286-07:002016-07-26T01:01:08.286-07:00Best articleBest articlesharad guptahttps://www.blogger.com/profile/11990643630709192125noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-36535238904775481322016-05-05T10:34:05.571-07:002016-05-05T10:34:05.571-07:00very nice article sir , keep posting !!very nice article sir , keep posting !!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-10601709634570890262015-08-27T11:09:07.814-07:002015-08-27T11:09:07.814-07:00Thanks, it's very useful.Thanks, it's very useful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-9796417500038364292015-08-10T04:54:21.069-07:002015-08-10T04:54:21.069-07:00thanksthanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-17379156396105225502015-08-10T04:43:00.929-07:002015-08-10T04:43:00.929-07:00thanksthanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-3154166809765485492015-05-15T04:09:45.262-07:002015-05-15T04:09:45.262-07:00SELECT EmpName,
...SELECT EmpName,<br /> (SELECT AgeGrpName<br /> FROM AgeGroup<br /> WHERE (Employee.EmpAge <= MaxAge) AND (Employee.EmpAge >= MinAge)) AS ageGroup<br />FROM EmployeeBalbhadra Singh Thakurnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46411274091326966942014-06-25T11:43:36.458-07:002014-06-25T11:43:36.458-07:00Employees Table
EmpName EmpID EmpAge
Raju 01 21
Ra...Employees Table<br />EmpName EmpID EmpAge<br />Raju 01 21<br />Rani 02 29<br />Anu 03 43<br /><br />AgeGroups Table<br />AgeGroupID AgeGroupName Min Age Max Age<br />1 Young Age 21 29<br />2 Middle Age 30 39<br />3 Old Age 40 60<br /><br />Q) write a query to display AgeGroupName based on Employee Age ?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-22878941300959039282014-06-05T02:02:45.970-07:002014-06-05T02:02:45.970-07:00Hi suresh,everything is fine and well explained bu...Hi suresh,everything is fine and well explained but the result of full outer join is not fit as per the query.<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-9972025452570790742014-06-04T23:37:13.492-07:002014-06-04T23:37:13.492-07:00thanks ....:)thanks ....:)xxxx yyyyyhttps://www.blogger.com/profile/11184335378470338164noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-43566097020904675662014-05-28T10:56:29.981-07:002014-05-28T10:56:29.981-07:00SImple and best article, indeed...SImple and best article, indeed...Anonymoushttps://www.blogger.com/profile/03844062370950071421noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-2783885587421558152014-05-18T02:00:39.510-07:002014-05-18T02:00:39.510-07:00Very nice and easy explanation , thanksVery nice and easy explanation , thanksAnonymoushttps://www.blogger.com/profile/01980728942032240735noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-54337375794505196622014-04-06T05:42:15.532-07:002014-04-06T05:42:15.532-07:00please can you give me INSERT, UPDATE and DELETE q...please can you give me INSERT, UPDATE and DELETE queries for the FULL OUTER join of above tables... I will be very much greatful to youAnonymoushttps://www.blogger.com/profile/12033098941460441468noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-27396781164016456012014-04-02T00:26:01.745-07:002014-04-02T00:26:01.745-07:00Simply,awesome....,Simply,awesome....,Anonymoushttps://www.blogger.com/profile/06453572067929726322noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-49665139295667378462014-03-16T02:32:03.483-07:002014-03-16T02:32:03.483-07:00it is very useful in my assignment
thanksit is very useful in my assignment <br />thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-48188774086702103322014-03-03T03:43:23.251-08:002014-03-03T03:43:23.251-08:00very good artical....very good artical....chanduhttps://www.blogger.com/profile/16795878184291078004noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-81678092731400468192014-02-12T21:46:49.815-08:002014-02-12T21:46:49.815-08:00Hi suresh,
Very good articles.Hi suresh,<br /> Very good articles.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-20203257799761606492014-02-08T03:50:35.477-08:002014-02-08T03:50:35.477-08:00good explanation.....................@@@@@@@good explanation.....................@@@@@@@Anonymoushttps://www.blogger.com/profile/17169611868176536122noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-45311944052691097262014-01-28T21:36:16.533-08:002014-01-28T21:36:16.533-08:00good explantaion & easy understanding.good explantaion & easy understanding.Anonymoushttps://www.blogger.com/profile/18144290040010418893noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-48757793403817393212014-01-28T21:04:09.561-08:002014-01-28T21:04:09.561-08:00Good one !!
Good one !!<br />Juber N Mulaninoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-75753619033958598712014-01-22T02:17:06.813-08:002014-01-22T02:17:06.813-08:00Hi sir,
I have a table which is called menutable....Hi sir,<br /><br />I have a table which is called menutable.<br /><br />it has a following field.<br /><br />SNO(Auto Increament), Menuname(varchar((20)), Submenu(int) , statuz(int)<br /><br />Sno is a primary key.<br /> <br />my question is how to set the sno is a foreign key for same table (submenu)<br /><br />please reply me............<br /><br />Thanks advanced.....Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-50758942081286534622013-12-12T00:08:29.375-08:002013-12-12T00:08:29.375-08:00Very nice yar...........Very nice yar...........Anonymoushttps://www.blogger.com/profile/05697686576710328915noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-45102929154172080642013-12-09T19:28:19.322-08:002013-12-09T19:28:19.322-08:00Thanks a lot......
Good ExplanationThanks a lot......<br />Good ExplanationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46872562968927282262013-11-26T20:26:53.496-08:002013-11-26T20:26:53.496-08:00Jee Bawro Ho Gayo :)Jee Bawro Ho Gayo :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-43509457400022016962013-11-24T20:58:58.507-08:002013-11-24T20:58:58.507-08:00good explanationgood explanationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-79259969040654649352013-11-10T23:40:37.272-08:002013-11-10T23:40:37.272-08:00nice explanation. nice explanation. Codefarihttps://www.blogger.com/profile/14275737213961436106noreply@blogger.com