Answer Posted / santosh kumar

SELECT EMPLOYEE_ID,LAST_NAME,SALARY,DEPARTMENT_ID
FROM (SELECT ROWNUM
R,EMPLOYEE_ID,LAST_NAME,SALARY,DEPARTMENT_ID FROM EMPLOYEES) A
WHERE A.R=&Record_Number;

---------------------------------------------
(This is easy method to find nth record from a table).....

Is natural join and inner join same?

489

---

What is AUTH_ID and AUTH_USER in pl/sql ?

1690

---

What is the use of prepared statement?

536

---

Are pl sql variables case sensitive?

590

---

How do I order columns in sql?

525

---

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

530

---

Explain the difference between triggers and constraints?

519

---

Is json a nosql?

541

---

How run sql*plus commands that are stored in a local file?

518

---

How can we link a sql database to an existing android app?

546

---

What is the most common sql injection tool?

543

---

What is database white box testing and black box testing?

634

---

What is sqlcontext?

549

---

What is an oracle stored procedure?

586

---

what is rdbms? : Sql dba

579

---