Answer Posted / ravikiran

select * from employee.e1 where (n-1) =
( select (distinct b.salary ) from employee.e2 where e1.salary > e2.salary

What type of locking occurs during the snapshot generation? : sql server replication

1261

---

Why are sql functions used?

1043

---

What is a subquery in a select query statement in ms sql server?

1065

---

Explain the different types of backups available in sql server? : sql server database administration

862

---

Can an entity have two primary keys?

925

---

What is store procedure? How do they work? When do you use?

885

---

What are the functions in sql server?

900

---

What are the pre-defined functions in the sql server?

1026

---

Does group by sort data?

845

---

What is cursors?

1094

---

How to create dbo table in sql server?

898

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1891

---

write an SQL query to list the employees who joined in the month of January?

1624

---

Explain transaction server consistency?

920

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

908

---