|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Pls check your answer practically first then only write it.WE cant use HAVING clause without group functions IT will show error.So pls mr.Rahul Be Carefull next time ... Latest Answer : Group by class will have to group all the data returing from the query in our specifed groups... so it is definitly an overhead from execution point of view... imagine that the number of rows returned by the query are in millions and you have to group ... 1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name Read Answers (1) | Asked by : lavanya Write sql query for retrieving employee names from employee table who are having salary greater than Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause? Read Answers (12) | Asked by : Ashok How to select Distinct columns from the table, table having 20 columns and i want all columns Latest Answer : SELECT DISTINCT *FROM Tabe1 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
