Answer Posted / nikhilesh roy

WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;

Which is better cte or subquery?

1018

---

Does user triggers have entry for trigger with compilation errors?

1022

---

Is sql workbench free?

976

---

What are the operators used in select statements?

1046

---

Why stored procedure is faster than query?

1039

---

Describe different types of general function used in sql?

1020

---

What is minus?

976

---

How do you get column names only for a table (sql server)?

1142

---

What does trigger mean in psychology?

951

---

Is there a 64 bit version of ssms?

947

---

what is heap table? : Sql dba

1094

---

How do I view a sql trace file?

1009

---

how can you create an empty table from an existing table? : Sql dba

1139

---

What is before trigger?

991

---

How do you sort in sql?

993

---