Answer Posted / jaishree singh

select emp_name,salary from
(select emp_name,salary, row_number() over (order by salary)
rownumber from employee) E
where E.rownumber = 3

What is the usage of sign function?

1040

---

What is collation sensitivity?

988

---

How to start sql server browser service?

1067

---

How can I tell if sql server is 32 or 64 bit?

903

---

What are dml triggers and types of dml triggers?

924

---

What is a transact-sql statement?

981

---

explain different levels of normalization? : Sql server database administration

932

---

How to create new table with "create table" statements?

998

---

Difference between aggregate functions of sql?

1042

---

How to delete duplicate rows?

932

---

What is 1nf 2nf and 3nf?

844

---

What is the difference between substr and charindex in the sql server?

1003

---

Can you create a logon trigger in sql server 2005 express edition?

1032

---

How can you control the amount of free space in your index pages?

1012

---

How to list all objects in a given schema?

987

---