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
when would you go for denormalization? : Sql server database administration
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
write down the code for "how we delete a table without using of Drop command " ?
7 Answers CarrizalSoft Technologies, Sonata,
What does the automatic recovery do?
How to receive output values from stored procedures?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is a table called, if it does not have neither Cluster nor Non-cluster Index?
How do I connect to sql server database?
What are the features of Embedded SQL
How raid can influence database performance?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
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)