About gaurav85

gaurav85 · ‎01-24-2022

Name Year Raj 1999 Rahul 2000 Rahul 2001 Rahul 2002 Sachin 2003 Suraj 2004 Harish 2005 Nihal 2006 Jim 2007 Jack 2008 Jack 2009 Jack 2010 Madan 2011 Madan 2012 Madan 2013 Name Jack Madan Rahul

gaurav85 · ‎01-24-2022

Hi Reeza, I am aware of the data step solution, In this particular case its a explicit ask to use SQL. I am not getting anything as of now in SQL

gaurav85 · ‎01-24-2022

Here is the data Name Year Raj 1999 Rahul 2000 Rahul 2001 Rahul 2002 Sachin 2003 Suraj 2004 Harish 2005 Nihal 2006 Jim 2007 Jack 2008 Jack 2009 Jack 2010 Madan 2011 Madan 2012 Madan 2013 output Name Jack Madan Rahul

gaurav85 · ‎01-24-2022

There is a table with name and year, I want to fetch the name of the person who won consecutive award three years via SQL query. Below is the result set.

gaurav85 · ‎01-24-2022

I have two tables Country Name(Country and Name) & Export/Import table ( Buyer or Importer and Seller or Exporter) and I want a third table or result set having export value or import value created from "value" column based on the buyer or seller name present group by country. The two tables and the result set is given below.

Online Status	Offline
Date Last Visited	‎01-24-2022 03:52 PM

Re: SQL

Re: SQL

Re: SQL

SQL: Find Consecutive Records

SQL: Combine And Aggregate Two Data Sets

SQL: Find Consecutive Records

Re: SQL

Re: SQL

Re: SQL

SQL: Find Consecutive Records

SQL: Combine And Aggregate Two Data Sets