what is the Querry Of Percentage?

Question

what is the Querry Of if i have a table in data base, i want that querry, who show me %, that how many percent record of data in a table?

Nitin Sontakke · Answer

You can use the attached script for the purpose. However it is slightly tricky to use it and simple if you follow the instructions. Copy and paste the lines between 17 to 22 into another query window, execute that query there and copy and paste the output (preferably in text format and not the grid format) at line 27. Then execute the entire script. You can adjust the order by clause at the last line as per your requirement. Hope it helps!

Pradeep Sahoo · Answer

Follow this link it may be useful http://stackoverflow.com/questions/7340266/get-count-percent-of-a-record-in-a-single-query

Prakash Kumar · Answer

Please refer the below links, http://www.sqlservercentral.com/scripts/Miscellaneous/31294/ http://www.sqlserver-dba.com/2010/04/table-sizes-and-percentages.html

Bilawal Niaz · Answer

If i have a table "CitizenDetail", in this table i have a 450 records, what is the querry to find percentage of 450 records,I want that querry,who show me %,That how many percent record of data in a table?

what is the Querry Of Percentage?

Answers (4)