Answer Posted / kishor

select max(salary ) from employee
where
sal<(select max(salary)from employee)

How do you explain an index?

1281

---

what is subquery? : Sql dba

1132

---

How do you determine the current isolation level? : Transact sql

1152

---

How many functions are there in sql?

1012

---

how to select unique records from a table? : Sql dba

1111

---

What is the use of count (*) in sql?

1051

---

What are the popular database management systems in the it industry?

996

---

How to write pl sql program in mysql command prompt?

1089

---

Explain sql data types?

1091

---

What is the maximum number of rows in sql table?

1025

---

Explain how to use transactions efficiently : transact sql

973

---

how to calculate the difference between two dates? : Sql dba

1059

---

What are %type and %rowtype for?

1052

---

Can you load data into multiple tables at once? : aql loader

1066

---

How to use distinct and count in sql query? Explain

1014

---