There is a table with pluks and zinks. Each pluk only resides on a single zink and each zink may contain multiple pluks. How do you find how many pluks are on each and every zink?

royalcrown

 Profile Answers by royalcrown Questions by royalcrown

• Aug 15th, 2011

Select zink_id,count(*) total from table_name group by zink_id;

goel_vibhore

 Profile Answers by goel_vibhore Questions by goel_vibhore

• Apr 12th, 2010

Select Zink, count(plunk) as Count from PZgroup by zink

Answer Question  Select Best Answer

There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10 304 35 25 355 20 40 40write a query to update column maxmarks such that maxmarks column contains whatever be the greater value among marks1...

indra.prasad

 Profile Answers by indra.prasad Questions by indra.prasad

• Jul 12th, 2010

CREATE TABLE aa(name varchar(10), marks1 int, marks2 int, maxmarks int);INSERT INTO aa VALUES ('a',10,20,null);INSERT INTO aa VALUES ('b',20,25,null);UPDATE aa SET maxmarks= CASE WHEN marks1 > marks2 THEN marks1 ELSE marks2 END;

Palash Biswas

 Profile Answers by Palash Biswas Questions by Palash Biswas

• May 20th, 2010

Declare @tbl_Test TABLE([Name] Nvarchar(255),Mark1 int,mark2 int,maxmark int) Insert into @tbl_Test([Name] ,Mark1 ,mark2) VALUES ('a',50,20) Insert into @tbl_Test([Name] ,Mark1 ,mark2) VALUES ('b',10,...

Answer Question  Select Best Answer