Answer Posted / srikanth

select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;

Is oracle and sql same?

575

---

how to check server status with 'mysqladmin'? : Sql dba

571

---

How do you rename a table in sql?

534

---

How do rank () and dense_rank () differ?

522

---

Which one is better subquery or joins?

557

---

---

What is the sql case statement?

579

---

How to run sql commands in sql*plus?

589

---

What is dml and ddl?

527

---

What are sql functions? Describe in brief different types of sql functions?

490

---

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

---

How do I partition a table in sql?

542

---

What are the rules to be applied to nulls whilst doing comparisons?

753

---

How do I start sql profiler?

561

---

what is 'mysqlimport'? : Sql dba

574

---

what are the advantages and disadvantages of views in a database? : Sql dba

533

---