Deleting duplicate rows from a table in SQL Server.

Deleting duplicate rows from a table in SQL Server:

Method 1:

Insert the distinct rows from the duplicate rows table to new temporary table. Delete data from table which has duplicate rows then insert the distinct rows from the temporary table as shown below.

select distinct * into #temp From tbltest delete from tbltest insert into tbltest                select * from #temp drop table #temp

Method 2:

Remove Duplicate Records by using ROW_NUMBER () or CTE

with CTE as (       select * , row_number() over (partition by CITY order by city) as rank       from tbltest ) delete from CTE where rank > 1

Program to print Fibonacci Numbers below 100 in c#

using System; class myclass {     static void Main()     {         int fn = 0;         int sn = 1;         int tn = 1;         Console.WriteLine(fn);         Console.WriteLine(sn);         while (true)         {             tn = fn + sn;             if (tn >= 100)             {                 break;             }             Console.WriteLine(tn);             fn = sn;             sn = tn;         }         Console.Read();     } }

Reverse a number using C#

using System; namespace Learn {     class Program     {         static void Main(string[] args)         {             Console.WriteLine("Enter a Number");             int numb = int.Parse(Console.ReadLine());             int reverse = 0;             while (numb > 0)             {                 int rem = numb % 10;                 reverse = (reverse * 10) + rem;                 numb = numb / 10;                            }             Console.WriteLine("Reverse number={0}", reverse);             Console.ReadLine();         }     } }