Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

What is type and rowtype in pl sql?

0 Answers  

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

How do you optimize a stored procedure query?

0 Answers  

---

what is view? : Sql dba

0 Answers  

---

What is foreign key and example?

0 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

---

What is the use of index in sql?

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---

What are character functions?

0 Answers  

---