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;

Which sorts rows in sql?

1057

---

Where is pl sql used?

1006

---

What are sql queries used for?

1079

---

how to create a new view in mysql? : Sql dba

989

---

What is the use of triggers?

1084

---

What is sqlerrd?

1016

---

What does <> sql mean?

1168

---

What is a .db file?

1043

---

Can we perform dml in function?

1135

---

Is sql open source?

1026

---

What is a scalar value in sql?

1126

---

What is a sql trace file?

1085

---

What are schema-level triggers?

1155

---

What is aggregate function in sql?

1080

---

Can a primary key be a foreign key?

1081

---