Answer Posted / d.elumalai

CREATE TABLE EMP (NAME VARCHAR2(20),SALARY NUMBER(10));

INSERT INTO EMP VALUES('AAA',10000);
INSERT INTO EMP VALUES('BBB',20000);
INSERT INTO EMP VALUES('CCC',30000);
INSERT INTO EMP VALUES('DDD',40000);
INSERT INTO EMP VALUES('EEE',50000);
INSERT INTO EMP VALUES('FFF',60000);
INSERT INTO EMP VALUES('GGG',70000);
INSERT INTO EMP VALUES('HHH',80000);
INSERT INTO EMP VALUES('III',90000);
COMMIT;

SELECT A.* FROM (SELECT name, salary FROM EMP ORDER BY salary DESC) A WHERE ROWNUM<=3;

Does mysql_real_escape_string prevent sql injection?

906

---

What is partition by in sql?

1000

---

What does pragma mean?

971

---

What is the difference between an inner and outer join?

959

---

How many sectors are in a partition?

1031

---

Can we call a function containing dml statements in a select query?

916

---

What is the difference between clustered and non-clustered index in sql?

956

---

What is pl sql in oracle?

989

---

What is a Mapplet?

1057

---

What is data types in sql?

950

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1976

---

How do I write a cron which will run a sql query and mail the results to agroup?

911

---

How do I enable sql encryption?

965

---

What is cursor in pl sql with examples?

952

---

Is vs as in pl sql?

932

---