cancel
Showing results for 
Search instead for 
Did you mean: 

How to fetch specific record in SQL database?

0 Kudos
639

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

MarkCulp
Participant

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

0 Kudos

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