Sai Pathrikar(सई पाथ्रीकर) Sql,Asp.Net,.NET,Html,Ajax,C#,Xml: 2017

Wednesday, June 21, 2017

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

Friday, June 9, 2017

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