Answer / shiva

select sal from emp group by sal;
this query group the same salary.Suppose the table contains 30
records in that same sal is 3 times repeating by using above
query it will fetch only 27 rows of sal.So it wont give the duplicate sal.

Answer / pankajsharma

it will fetch all the salaries one tme in case of duplicacy

Answer / arun karthick

select sal from emp group by sal; and select distinct sal
from emp ;
Both queries will give the same result - fetch the salary
in emp table without duplicates.

how to write date and time literals? : Sql dba

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

Why does sql need a server?

0 Answers  

---

how to create a database in oracle?please gve anser with example

1 Answers  

---

What is varchar sql?

0 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

What is cascade in sql?

0 Answers  

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

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

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

---