Can we use having without group by in sql?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between where clause and having clause? : Sql dba
What are schema-level triggers?
what are the different types of joins?
Is record in pl sql?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
how to sort records in sql?
What are pl/sql exceptions? Tell me any three.
What are joins in sql?
What is Materialized View? In What Scenario we Use Materialized View?
Explain isolation levels. : Transact sql
Explain the uses of database trigger.
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
Oracle (3259)
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)