what is sql? : Sql dba

0 Answers  

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

How do you remove duplicates without using distinct in sql?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What is the difference between left outer join and left join?

0 Answers  

---

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

---

How many types of normalization are there?

0 Answers  

---

What do you mean by “trigger” in sql?

0 Answers  

---

How many sectors are in a partition?

0 Answers  

---

What is sql profiler in oracle?

0 Answers  

---