Answer Posted / aman kaushal

select salary from customer order by salary desc limit n,1;

here n is the array value 1st highest value starts with 0
value and then 1.

e.g

find the 2nd highest salary.

select salary from customer order by salary desc limit 1,1;

What is relationship? What number of sorts of relationship are there?

1224

---

What the different components in replication and what is their use?

1000

---

What is a derived table?

994

---

Explain a differential backup?

1064

---

How to copy the tables, schema and views from one sql server to another?

1106

---

If a stored procedure is taking a table data type, how it looks?

6524

---

What is the difference between char, varchar and nvarchar?

1079

---

What is sparse columns of sql server 2008?

1101

---

Can we write ddl in trigger?

972

---

Can I delete event logs?

979

---

What are the requirements for sql server 2016?

934

---

How to display a past time in days, hours and minutes?

1061

---

Why we need sql server?

1015

---

How to create prepared statements using odbc_prepare()?

1106

---

How to execute multiple stored procedures at one time in sql server?

1067

---