Answer Posted / ajay kumar barik

select a.id from product a where (1= (select count(b.id)
from product b where b.id>=a.id))


It is for all database

How to create a new schema in a database?

756

---

List some major differences between triggers and stored procedures?

689

---

Define a cross join?

760

---

Do you know how to make remote connection in database?

714

---

What are the restrictions applicable while creating views? : SQL Server Architecture

757

---

What is the command to change the recovery model?

763

---

What is an expression in ms sql server?

729

---

What are the differences between stored procedure and view in sql server?

841

---

How many types of stored procedures are there in sql server?

740

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

713

---

What is tablesample?

766

---

Explain identity in sql server?

722

---

Why use “in” clause in sql server?

732

---

how can u get last observation in an unknown dataset ?

2187

---

What is deploy, process and build? : sql server analysis services, ssas

755

---