Interested to Buy Any Domain ? << Click Here >> for more details...
Which is faster view or stored procedure?
- 0 Answers
- 946 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is oracle sql,pl/sql with interfaces
Are subqueries better than joins?
what is top in tsql? : Transact sql
How does a self join work?
How do we use distinct statement? What is its use?
what is a constraint? Tell me about its various levels. : Sql dba
What is a primary key? Explain
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.
write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
Why do we need unique key in a table?
What does sql stand for?
what is the difference between nested subquery and correlated subquery?
-
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)
