Answer Posted / zeljko

This answer_10 will work only if there is not order by used
on select statement.
I recommend using dense_rank function to get second row out
as in example;

SELECT * FROM (
SELECT id, first_name, salary,
DENSE_RANK() OVER(ORDER BY salary desc) row_order
FROM employee)
WHERE row_order = 2;

what is the difference between delete and truncate commands? : Sql dba

1119

---

What is the difference between a procedure and a function?

1214

---

What is numeric function sql?

1107

---

How many sql core licenses do I need?

995

---

What are the sql commands?

1230

---

Explain what is sql*plus?

1196

---

how to write date and time literals? : Sql dba

1010

---

Define tables and fields in a database

1177

---

What are the different types of dbms?

1065

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1893

---

What is pragma in sql?

1127

---

What is the primary key?

1002

---

Explain clause in sql?

1073

---

Explain the select statement in sql?

1183

---

what is dbms? : Sql dba

1036

---