Answer Posted / neeraj sharma

select ename,sal from emp where rownum<=3 order by sal desc

Note:- every table has rownum column but it is hidden by
default you can see it by this
select rownum from your_table_name

What are parameterized reports? What are cascading parameters in ssrs reports?

156

---

Is foreign key unique?

993

---

Can you explain different types of locks in sql server?

945

---

How do I save a stored procedure in sql server?

994

---

What is the use of group by clause?

939

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1043

---

How to resolve the orphan use problem? : sql server security

1014

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1132

---

What is the recovery model? List the types of recovery model available in sql server?

901

---

What is the process of normalization?

1120

---

Define cross join in sql server joins?

1019

---

Explain what is sql server english query?

1044

---

Explain raiserror in sql server?

1017

---

How to create a new table in a given schema?

1182

---

How to how to convert numeric expression data types using the convert() function??

1047

---