Question Re: How to fetch specific record in SQL database? in Technology Q&A

How to fetch specific record in SQL database?

former_SQLA_member1695054 — Fri, 14 Oct 2022 06:45:49 GMT

Hello there, I have a database related to different fonts. There are millions of records in the database. Now I want to fetch the specific record from the specific table in the database. Can anyone tell me how it possible. Thanks in advance.

Re: How to fetch specific record in SQL database?

MarkCulp — Fri, 14 Oct 2022 07:09:10 GMT

You will need to use a WHERE on your SELECT statement. The condition used in the WHERE clause will be dependent on your database schema. If your table has a primary key then the form will be

SELECT column FROM table WHERE pk = val

There are many online SQL tutorials. You may benefit from googling "SQL tutorial" and going through the resources.

HTH

Re: How to fetch specific record in SQL database?

former_SQLA_member1695054 — Fri, 14 Oct 2022 07:25:34 GMT

Thank you so much for helping me. I will follow the following instructions to solve my problem.