TEXT TO SPEECH IN CONSOLE APPLICATION

note : add new abstract class

 abstract class _absract
{
        public abstract string GetDate();
        public virtual string GetVirtualData()
        {
            string str = "H! I am from Virtual...";
            Console.Write(str);
             return str;
        }

}

step 2: add new 2nd class

using System.Speech.Synthesis;
namespace factorialprog_7.RAJU_MAMA.abstract7
{
    class Non_abstract : _absract
    {
        public override string GetDate()
        {   

            string Time = "The Time Is: " + System.DateTime.Now.ToShortTimeString();
            string Date= "The Date Is: " + System.DateTime.Now.ToShortDateString();
            Console.WriteLine(Time +" " + Date);
            return Time + Date;
        }
        public override string GetVirtualData()
        {
            string str = "Bye I Am From Override...";
            Console.WriteLine(str);
            return str;
        }

        static void Main()
        {
            Non_abstract NA = new Non_abstract();

            SpeechSynthesizer synthesizer = new SpeechSynthesizer();
            synthesizer.Volume = 100;
            synthesizer.Rate = -2;

         
            synthesizer.Speak(NA.GetVirtualData());
            synthesizer.Speak(NA.GetDate());
           
            Console.ReadLine();



        }


    }
}


it's work plz comment if any query

HOW TO GET 3RD Highest Employee Salary In Sql 2008 R2

Ans:


Step 1 : Create Table

CREATE TABLE Tbl_Salary
(
    id int NOT NULL primary key,
    Name nvarchar(max) NULL,
    Salary money NULL
)

Then Step 2 : Insert Employee Record


 insert Tbl_Salary values (1001,'Atul Pathrikar',10000);
insert Tbl_Salary values (1002,'Sai Pathrikar', 9000)
insert Tbl_Salary values (1003,'Pravin Pathrikar',8000)
insert Tbl_Salary values (1004,'Vijay Pathrikar',7000);
insert Tbl_Salary values (1005,'Vishal Pathrikar',6000);
insert Tbl_Salary values (1006,'Rohit Pathrikar',5000);
insert Tbl_Salary values (1005,'Kartik Ingle',4000);

Tbl_Salary

 Step 3: Type 1st For Get 3RD highest Salary



SELECT Max(salary)
FROM   Tbl_Salary
WHERE  salary <
 (SELECT Max(salary)  FROM   Tbl_Salary
                 WHERE  salary NOT IN(SELECT Max(salary)
                                      FROM   Tbl_Salary))
                                  
                                   
                                     
                                     

3Rd Highest Salary

                                                                          OR

 Type 2nd To Get 3rd Highest Salary:

SELECT TOP (1) * FROM
   (SELECT TOP (4) Salary ,Name FROM Tbl_Salary ORDER BY salary DESC)
  Salary
ORDER BY salary ASC

3Rd Highest Salary

                                                                           OR

Type 3rd Get 3rd Highest Salary Using CTE(Common Table Expression)

create proc SP_Gethigestsal
(
@higestsalposition int
)
as
with Tbl_ctesal as
(
select *, DENSE_RANK() over(order by salary desc) as HigestSal from Tbl_Salary
)
select Name,Salary from Tbl_ctesal where HigestSal=@higestsalposition
return

--exec  SP_Gethigestsal 3

With CTE Get 3rd Highest Salary

 Try This  Any this 3 Step To Get 3rd Highest Salary

Note: You Also Get 2nd,4th,5th,6th,7th Highest Salary using This Any 1 Sql Query





Thank You For Visit my blog


if you have any query Comment And Share blog,
My YouTube Channel Name: TheAtulpathrikar7,   Atul Pathrikar
watch my all programming and Sql videos on Youtube ,

My-Email_ID: pathrikaratul7@gmainl.com
                       pathrikaratul7@rediffmail.com

send me youre Query on My Mail ID


My Mobile Number : +91-9673178777







Thank You Friends

AP8777

Get 3rd Higest Max salary in Sql query