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

Can one drop a column from a table?

1020

---

What are differences in between sql server 2012 and sql server 2016?

1050

---

How do I perform an unattended install of sql server 2000?

1086

---

Explain ms sql server reporting services vs crystal reports?

919

---

What is instead of dml trigger?

1004

---

What is the default order of an order by clause?

997

---

What are the steps to follow to configure SQL*Net?

1044

---

What is the default server name for sql server?

1171

---

How to convert numeric values to integers in ms sql server?

1093

---

Relational calculus is what type of language?

1037

---

What is SubQuery in SQL Server 2008

1024

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1204

---

what is a mixed extent? : Sql server administration

1105

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

964

---

How to retrieve error messages using odbc_errormsg()?

1059

---