How to fetch specific record in SQL database?

-2

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.

mssql

asked 14 Oct '22, 06:45

sorhelene2
9●2
accept rate: 0%

edited 14 Oct '22, 07:12

Graeme Perrow
9.6k●3●79●124

flat view

One Answer:

active answers oldest answers newest answers popular answers

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

permanent link

answered 14 Oct '22, 07:09

Mark Culp
24.7k●9●138●294
accept rate: 41%

edited 14 Oct '22, 07:10

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

(14 Oct '22, 07:25) sorhelene2

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

mssql ×40

question asked: 14 Oct '22, 06:45

question was seen: 185 times

last updated: 14 Oct '22, 07:25

SAP SQL Anywhere

How to fetch specific record in SQL database?

Follow this question

Related questions