Answer Posted / anil pednekar

select * from (select sal from table1 group by sal ) where
row num=3

which types of join is used in sql widely? : Sql dba

969

---

What is package in pl sql?

1001

---

What is the maximum rows in csv?

911

---

What is sap sql?

960

---

what are aggregate and scalar functions? : Sql dba

1041

---

How do I count rows in sql?

983

---

Why do we create stored procedures & functions in pl/sql and how are they different?

927

---

Is left join inner or outer by default?

1006

---

How many types of literals are available in pl sql?

1099

---

how do you tune the slow running queries in oracle db , explain the methodology

2582

---

How delete all data from all tables in sql?

933

---

What is sql keyword?

981

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4251

---

What is a boolean in sql?

965

---

how to include character strings in sql statements? : Sql dba

1047

---