Answer / guest

select max(sal) from tab_name;
or
select * from tab_name where sal=(select max(sal) from
tab_name) and rownum<=1;

Answer / prashant

select max(salary) from
(select distinct(salary) from ABC)

What are the different types of database management systems?

0 Answers  

---

How to check if a column is nullable before setting to nullable?

0 Answers  

---

how to saw triggers output in pl/sql database?

1 Answers  

---

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

---

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

Is sql procedural language?

0 Answers  

---

What is a design view?

0 Answers  

---

Can we use views in stored procedure?

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---