Answer Posted / anish tuladhar

select
distinct salary
from
(
select
DENSE_RANK() over(order by salary desc) as rnk,
modelyr_id_int
from
employee
) a
where
rnk = 4

Should you normalize audio?

923

---

Equi join and non equi join is possible with sql server?

997

---

what is database replicaion? : Sql server database administration

1164

---

Which joins are sql server default?

979

---

How to create a dml trigger using create trigger statements?

1013

---

Why do we backup Active Directory ?

1029

---

What is the use of “join” in sql server?

1065

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2910

---

what information is maintained within the msdb database? : Sql server administration

945

---

Are semicolons required at the end of sql statements in sql server 2005?

965

---

What is collation?

1126

---

What is a partitioned view?

975

---

What are the rendering extensions of ssrs?

153

---

Do you know concepts and capabilities of sql server?

1044

---

How check triggers in sql server?

966

---