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
Differentiate between a having clause and a where clause.
How many null values we can have in a unique key field in sql server?
Explain steps of normalization?
What are system databases into sql server (2005/2008)?
when inserting to a table how many rows will be effected using triggers
Explain important index characteristics?
What is normalization in Database ?
what is web server?
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
4 Answers CarrizalSoft Technologies, L&T,
Do you know how to send email from database?
What is the difference between DTS and SSIS?
Explain DBCC?
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)