Answer / chandrasekar.ramasamy

user_source

Answer / rajesh

user_objects
user_source
user_dependencise
ideptree

Answer / sam

user_object

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

1 Answers  

---

Does sql backup shrink transaction log?

0 Answers  

---

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

What are all different types of collation sensitivity?

0 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

What is embedded sql in db2?

0 Answers  

---

what is offset-fetch filter in tsql? : Transact sql

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---