Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pravati
In two ways we can use count
1. SELECT COUNT(*) FROM table name.
2.SELECT COUNT(DISTINCT *) from table name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can group functions be mixed with non-group selection fields in ms sql server?
What are various aggregate functions that are available?
How to delete all rows with truncate table statement in ms sql server?
do you know how to configure db2 side of the application? : Sql server database administration
Can we return Data from 4(more than 1) tables in stored procedure?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to create a scrollable cursor with the scroll option?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Why it is recommended to avoid referencing a floating point column in the where clause?
Explain the dirty pages?
What is the difference between ddl,dml and dcl commands?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Explain forward - only cursors?
