Answer Posted / umesh naik

select max(amount) from (
select distinct amount from temp123
where rownum <= 3
)

how to use myisamchk to check or repair myisam tables? : Sql dba

910

---

Explain what is sql*plus?

1084

---

Is sql procedural language?

919

---

How will you distinguish a global variable with a local variable in pl/sql?

1090

---

What will you get by the cursor attribute sql%notfound?

1011

---

Show the cursor attributes of pl/sql.

995

---

how to use regular expression in pattern match conditions? : Sql dba

962

---

Can we use having without group by in sql?

926

---

how to get a list of all tables in a database? : Sql dba

917

---

What is the difference between having clause and where clause?

1008

---

what is the different between now() and current_date()? : Sql dba

933

---

What is trigger and types?

964

---

What is a table in a database?

990

---

How to run sql commands in sql*plus?

1081

---

how do you login to mysql using unix shell? : Sql dba

1015

---