Answer Posted / ramesh babu

Create table #tempempid(Employeeid int,age int)
Create table #tempempregion(Employeeid int,Region varchar
(200))

Insert into #tempempid(Employeeid,age)values(100,25),
(101,35),(103,35),(104,10),(105,12),(106,11),(107,13),
(108,24),(109,22),(110,17),(111,11),(112,25),(113,100) ,
(52,100)
go
Insert into #tempempregion(Employeeid,region)values
(100,'SA'),(102,'SA'),(103,'UK'),(104,'UK'),(105,'PHL'),
(106,'US'),(107,'US'),(108,'US'),(109,'RSA'),(110,'RSA'),
(111,'UK'),(113,'SA'),(52,'CA')

Select T.region,T.Age from
(
Select b.region as Region,a.age as Age,
rank() over(order by age desc) as Rnk
from #tempempid a inner join #tempempregion b on
a.Employeeid=b.Employeeid
)T
Where T.Rnk=1

What is in place upgrade in sql server?

1093

---

How to loop through the result set with @@fetch_status?

1431

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

957

---

What is thr feature of change data capture?

1033

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1087

---

What is subquery in sql?

1129

---

What are the types of table?

1031

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1004

---

What is the difference between dbcc indexdefrag and dbcc reindex?

1040

---

Mention the differences between having and where clause.

1120

---

List out some of the requirements to set up a sql server failover cluster?

1076

---

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

1047

---

How to get the definition of a stored procedure back?

1020

---

What is data mart? : sql server analysis services, ssas

1111

---

please differentiate between delete and truncate?

1038

---