Answer Posted / atheeq

select distinct emp_sal from emp where 1 order by emp_sal
desc limit 1,1

Is it possible to sort a column using a column alias?

1055

---

What are inner and outer joins examples of both?

967

---

How do I count rows in sql query?

998

---

Explain aggregate functions are available there in sql?

1012

---

Why use truncate instead of delete?

1020

---

Is like operator in sql case sensitive?

1031

---

How do you explain an index number?

1114

---

What are different types of indexes?

1014

---

Can we use update in sql function?

1069

---

what is “go” in t-sql? : Transact sql

1113

---

what is meant by urlencode and urldocode? : Sql dba

1180

---

What are the benefits of pl/sql packages?

1107

---

What is execution plan in sql?

1053

---

How do I kill a query in postgresql?

1142

---

how many columns can be used for creating index? : Sql dba

949

---