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
5 9902Post New ZX SQL Server Interview Questions
What is the difference between ienumerable and enumerable?
Give an idea of system variables.
What is maximum power transfer theorem?
What is Transactional based Application & Role based Application?
What is the new layout mode in css3?
Write a VB.Net console program to check whether a number is perfect or not.
Which collection type is used to maintain uniqueness of data structure?
How do we represent data in Spark?
What is one way data binding in angularjs?
What is an abstract method?
What is the ls command in windows?
How to create a tuple in swift?
How to tokenize a string in c++?
cics command level is?
How to pump the data from one database to another?