Answer Posted / nikhilesh roy

WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;

Why do we use procedures in sql?

550

---

What is substitution variable?

583

---

What trigger means?

567

---

Is a foreign key always unique?

534

---

what are the 'mysql' command line arguments? : Sql dba

652

---

---

what is 'mysqlcheck'? : Sql dba

575

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

486

---

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

546

---

what is timestamp in mysql? : Sql dba

568

---

which types of join is used in sql widely? : Sql dba

542

---

What is the use of triggers?

545

---

How do we accept inputs from user during runtime?

548

---

How many types of normalization are there?

493

---

What is the difference between delete, truncate and drop command?

552

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

586

---