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

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1049

---

Why do we use sqlite?

991

---

Write a sql select query that only returns each name only once from a table?

1028

---

What is benefit of creating memory optimized table?

984

---

what is the difference between $message and $$message? : Sql dba

1008

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1157

---

What is sqlcontext?

1091

---

What are the commands used in sql?

1091

---

What is the location of pre_defined_functions.

1174

---

What is procedure and function?

1001

---

what are string data types? : Sql dba

1053

---

Can function return multiple values in sql?

1066

---

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

1588

---

How do I save a stored procedure?

1020

---

What is a constraint? Tell me about its various levels.

1177

---