How do I get the right SQL setup?

Question

I can't seem to get the SQL setup that goes like this: ''SELECT, WHERE, FROM''. Please give me a step-by-step guide to help me get this setup. I can't seem to find an app that has this setup anywhere I look on the internet.

Answer 1

Hi @Jonas Levesen Thanks for posting your question in the Microsoft Q&A forum.

If I understand correctly you are looking for guidance on how to set up a SQL query with the "SELECT, WHERE, FROM" structure.

The SQL query structure you are referring to is called a SELECT statement. It is used to retrieve data from a database table you can follow the below document

https://learn.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15

https://learn.microsoft.com/en-us/sql/ssms/quickstarts/ssms-connect-query-sql-server?view=sql-server-ver15

SELECT column1, column2, ... FROM table_name WHERE condition;
Replace "column1, column2, ..." with the names of the columns you want to retrieve data from. Replace "table_name" with the name of the table you want to retrieve

Let me know if you need any additional details

Regards

Geetha

Answer 2

Hi @Jonas Levesen,

Do you mean that you want to write the sql query in sql server but you could not find the location?

If yes, you may download SSMS which is an integrated environment for managing any SQL infrastructure.

SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.

Check Server Management Studio (SSMS)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

I can't seem to get the SQL setup that goes like this: ''SELECT, WHERE, FROM''.

Setup = Installation versus DML command?

Sorry, your post is very unclear, please describe more detailed what you are looking for / what the issue is.