Answer Posted / jeevitha

select distinct a.salfrom emp a where &n= (select count
(distinct(b.sal)from emp b where a.sal<= b.sal)
-----
enter the highest sal of n:2,3.....n

what are the authentication modes in sql server? : Sql dba

537

---

Are stored procedures compiled?

525

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1067

---

Which join condition can be specified using on clause?

517

---

what is myisam? : Sql dba

578

---

---

What is crud stand for?

570

---

What is the difference between partitioning and sharding?

530

---

Explain about various levels of constraint.

525

---

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

910

---

Can we join two tables without common column?

516

---

Explain what is rdbms?

586

---

How to find 3rd highest salary of an employee from the employee table in sql?

571

---

How to write html code in pl sql?

583

---

What are the basic sql commands?

551

---

What is java sql driver?

550

---