How to retrieve a specific users’ data from SQL Server?

by

From your description, What I understood is you have a table with the following details

Sample Table

And you want to sort only the record of Wolf Like this

Sample Result

If this is the case then you can just use a simple select Query with a where condition, like this

SELECT * FROM YourTable WHERE UserName="wolf";

More Related Contents:

  1. Get the mentioned output by SQL query
  2. Sql Mathematical calculations [closed]
  3. Exclude a column using SELECT * [except columnA] FROM tableA?
  4. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  5. Conditional WHERE clause in SQL Server
  6. How to Join to first row
  7. Concatenate row values T-SQL
  8. How to return multiple values in one column (T-SQL)?
  9. Difference between “read commited” and “repeatable read”
  10. Reference alias (calculated in SELECT) in WHERE clause
  11. Implement paging (skip / take) functionality with this query
  12. Copy data into another table
  13. When to use Common Table Expression (CTE)
  14. How to replace a string in a SQL Server Table Column
  15. How to send email from SQL Server?
  16. SQL server ignore case in a where expression
  17. How To Create Table with Identity Column
  18. Find closest date in SQL Server
  19. SQL Server LIKE containing bracket characters
  20. How to copy a huge table data into another table in SQL Server
  21. Alternate of lead lag function in SQL Server 2008
  22. “Order By” using a parameter for the column name
  23. DISTINCT for only one column
  24. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  25. How do I create and query linked database servers in SQL Server?
  26. Add emoji / emoticon to SQL Server table
  27. Perform regex (replace) in an SQL query
  28. What is the internal representation of datetime in sql server?
  29. Eliminate and reduce overlapping date ranges
  30. Export table data from one SQL Server to another

Leave a Comment