how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
No Answer is Posted For this Question
Be the First to Post Answer
What does this statement do @@rowcount?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Does partitioning help performance?
Can another user execute your local temporary stored procedures?
What is database white box testing?
How do you find the number of rows in a table?
How to change the name of a database user?
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 is the use of keyword with encryption.
How can sql server instances be hidden?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
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)