Difference between uniqe index and uniqe constraint?
No Answer is Posted For this Question
Be the First to Post Answer
Define outer join in sql server joins?
How to disable triggers using "disable trigger"?
how can you check the level of fragmentation on a table? : Sql server administration
What is merge join?
What are the dis_advantages of stored procedures, triggers, indexes?
Can we call stored procedure in view in sql server?
what are the types of indexes? : Sql server database administration
What are the steps need to be take improve the speed of a SQLDATA Server?
Detail about query optimizer?
what operator performs pattern matching?
Give an example of why you would want to denormalize a database
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2