how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

what are the types of join and explain each? : Sql dba

0 Answers  

---

What does trigger mean in slang?

0 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

What is an alias command?

0 Answers  

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

How do you modify a table in sql?

0 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

What is a schema? How is it useful in sql servers?

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

---