What is the need for group functions in sql?
No Answer is Posted For this Question
Be the First to Post Answer
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Why use cursor in sql server?
what is a cursor and what is its use?
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
what information is maintained within the msdb database? : Sql server administration
List the advantages of using stored procedures?
Explain what are various ways to enhance the ssrs report?
What is the use of group by clause?
How can you see what type of locks used?
What is inline table-value user-defined function?
What do you mean by normalisation?
what are acid properties? : Sql server database administration
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)