Answer Posted / sandeep

select top(1) a.salary
from

(
select top(2)sal
from
employee
order by salary desc
)a
order by a.salary asc

What is sql indexing?

965

---

What is a database trigger?

1019

---

What is lexical units in pl sql?

1055

---

What is int identity in sql?

1064

---

What does bitemporal mean?

1010

---

What is sequence in sql?

945

---

How can use stored procedures in sql?

1083

---

What is a pragma statement?

1204

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

989

---

How do you exit in sql?

1065

---

What is difference between stored procedure and trigger?

1061

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

956

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1384

---

What company owns postgresql?

963

---

Explain the purpose of %type and %rowtype data types?

876

---